| Author |
Message |
|
tjc
|
 Posted: Mon Feb 26, 2007 11:35 pm |
|
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
|
OK, so far so good. Double check that against mythconverg.sql.bz2.1 for sanity sake.
|
|
| Top |
|
 |
|
ninten
|
Posted: Mon Feb 26, 2007 11:39 pm |
|
|
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
|
Code: root@mythtvbk:/home/mythtv# bzip2 -dc /myth/backup/mythconverg.sql.bz2.1 | grep 'CREATE TABLE' | wc -l
67
|
|
| Top |
|
|
|
tjc
|
Posted: Mon Feb 26, 2007 11:48 pm |
|
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
Excellent.
Manual restore time. Shutdown the backend, the frontend, anything that might restart them, and anything else (aside from mysql) that might diddle the DB, and verify that they really are down. Then run:
Code: /usr/bin/mysql -u root mythconverg </myth/backup/mythconverg.sql Ignore any complaints about tables or records that already exist, but keep a sharp eye out for anything else. When you're done run: Code: checkrestore
Note that we're being very careful not to restart the backend or frontend here until we know that the DB is in reasonable shape.
|
|
| Top |
|
|
|
tjc
|
Posted: Mon Feb 26, 2007 11:51 pm |
|
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
BTW - My brain is melting, so if I disappear, figure I fell asleep and will be back tomorrow... 
|
|
| Top |
|
|
|
ninten
|
Posted: Tue Feb 27, 2007 7:17 am |
|
|
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
|
No problem! Hehe. My head was smacking against my monitor before your previous post and I had to give in and go to bed  . I'll try the manual restore when I get home from work at around 5PM EST and update you on how it went!
|
|
| Top |
|
|
|
ninten
|
Posted: Tue Feb 27, 2007 5:14 pm |
|
|
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
|
I know you said to ignore errors that tables already exist, but everytime I run
Code: /usr/bin/mysql -u root mythconverg I get an error that a certain table already exists. No matter how many times I try to run it I get the same error. Code: root@mythtvbk:/home/mythtv# /usr/bin/mysql -u root mythconverg </myth/backup/mythconverg.sql
ERROR 1050 (42S01) at line 11: Table 'callsignnetworkmap' already exists
root@mythtvbk:/home/mythtv# /usr/bin/mysql -u root mythconverg </myth/backup/mythconverg.sql
ERROR 1050 (42S01) at line 11: Table 'callsignnetworkmap' already exists
|
|
| Top |
|
|
|
tjc
|
Posted: Tue Feb 27, 2007 8:29 pm |
|
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
ninten wrote: I know you said to ignore errors that tables already exist, but everytime I run Code: /usr/bin/mysql -u root mythconverg I get an error that a certain table already exists. No matter how many times I try to run it I get the same error. Hmm.. I was half afraid of that. Check the mysql manual page for a command line option to ignore errors like that. Code: man mysql Otherwise we can drop and create the DB again... OBTW - I fthis gives us a reasonable restore I'm going to pin the blame on the backend and strongly suspect a bad CD image. It might be a good idea to start DL-ing a fresh copy from a different mirror, check the md5sum , .... If you keep the old one around you can use the cmp command to see if they're identical. Code: man cmp
|
|
| Top |
|
|
|
ninten
|
Posted: Tue Feb 27, 2007 9:28 pm |
|
|
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
|
K, completed the manual restore and ran checkrestore:
Code: Checking for the existance of the DB dump file...
DB dump file exists. Checking the compression...
Compression looks OK. Checking DB dump contents...
Generating a list of tables and record counts in the DB dump...
Generating a list of tables and record counts in the live DB...
Comparing live versus saved tables...
42c42
< recorded 441
---
> recorded 443
Warning, table lists are not identical!
The restore failed or was already modified!
Here's more evidence... Code: root@mythtvbk:/home/mythtv# mysql -u root mythconverg -e "select count(*) from settings"
+----------+
| count(*) |
+----------+
| 917 |
+----------+
root@mythtvbk:/home/mythtv# ls -al /var/lib/mysql/mythconverg/ | wc -l
205
Looks like its pretty good... So should we go with this, or try and burn a new disk and try Auto-Upgrade again?
|
|
| Top |
|
|
|
tjc
|
Posted: Tue Feb 27, 2007 10:23 pm |
|
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
|
It won't hurt to go with it at this point since you'd need to reupgrade it goes all pear shaped anyway. If it disappears again, it'll be time to try a new CD.
|
|
| Top |
|
|
|
ninten
|
Posted: Wed Feb 28, 2007 7:08 am |
|
|
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
|
Ok I'll give it a go. Thanks for your determination and help! It is very much appreciated. 
|
|
| Top |
|
|
View unanswered posts
View active topics
Print view
Previous topic Next topic 
LinHES Home
Board index
FAQ
Search
Login 
Register
