[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mythtv-users
Subject:    [mythtv-users] getting error when restoring database
From:       "Johnny Russ" <jruss () mit ! edu>
Date:       2008-06-11 16:16:56
Message-ID: c7c911b10806110916y40ef98c8g5ec9b0ba9bf765da () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


I just moved my system to new hardware. At first I just copied my database
over from my backup of /var/lib/mysql. However, this gave errors with the
mythweather tables. It says there are 93 tables but when you browse there
are only 90 tables. The three mythweather tables are missing. I tried
uninstalling reinstalling mythweather but neither of those recreate the
tables. I tried deleting the 'WeatherDBSchemaVer' row from settings and then
reinstalling but that didn't work. I don't really even want mythweather, but
mythweb won't lauch because it says it can't find the mythweather tables. My
last attemp was to drop the mythconverg database and restore it from my
daily backups. When I run this command:

/var/backups$ mysql -u root -p mythconverg < mythconverg.daily.sql.gz

I get this error: ERROR at line 1: Unknown command '\5'.

Any help on this error would be greatly appreciated. Or any other ideas how
to get me back in shape with or without mythweather would be helpful.

[Attachment #5 (text/html)]

I just moved my system to new hardware. At first I just copied my database over from \
my backup of /var/lib/mysql. However, this gave errors with the mythweather tables. \
It says there are 93 tables but when you browse there are only 90 tables. The three \
mythweather tables are missing. I tried uninstalling reinstalling mythweather but \
neither of those recreate the tables. I tried deleting the &#39;<font size="2" \
color="black" face="Verdana,Arial,Helvetica"><font size="2" color="black" \
face="Verdana,Arial,Helvetica">WeatherDBSchemaVer&#39; row from settings and then \
reinstalling but that didn&#39;t work. I don&#39;t really even want mythweather, but \
mythweb won&#39;t lauch because it says it can&#39;t find the mythweather tables. My \
last attemp was to drop the mythconverg database and restore it from my daily \
backups. When I run this command:<br> <br>/var/backups$ mysql -u root -p mythconverg \
&lt; mythconverg.daily.sql.gz<br><br>I get this error: ERROR at line 1: Unknown \
command &#39;\5&#39;.<br><br>Any help on this error would be greatly appreciated. Or \
any other ideas how to get me back in shape with or without mythweather would be \
helpful.<br> <br></font></font>



_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[prev in list] [next in list] [prev in thread] [next in thread]