LinHES Forums http://forums.linhes.org/ |
|
Unable to Restore Database http://forums.linhes.org/viewtopic.php?f=21&t=23793 |
Page 2 of 2 |
Author: | RacerX [ Fri Jul 19, 2013 2:43 pm ] |
Post subject: | Re: Unable to Restore Database |
Made a little progress today with the issue. /usr/LH/bin/lh_system_restore_job backup.2013-07-13_21-50.tgz cleanup Noticed that it gave a message that mythconverg might become unsable and would be it in the tmp directory So ran myth-setup and the flags cames out but I could see a window behind that said "upgrade to 1299" This didn't do much so I looked in the tmp directory and here's listing Code: [root@mythsrv /]# find /tmp -name mythconverg* /tmp/mythconverg--20130719152217.sql.gz /tmp/mythconverg--20130719144752.sql.gz /tmp/mythconverg--20130719152305.sql.gz /tmp/mythconverg--20130719150634.sql.gz /tmp/mythconverg--20130719150244.sql.gz /tmp/mythconverg--20130719150756.sql.gz /tmp/mythconverg--20130719144638.sql.gz /tmp/mythconverg--20130719151428.sql.gz /tmp/mythconverg--20130719151102.sql.gz /tmp/mythconverg--20130719151437.sql.gz /tmp/mythconverg--20130719152450.sql.gz /tmp/mythconverg--20130719150502.sql.gz /tmp/mythconverg--20130719151648.sql.gz /tmp/mythconverg--20130719152412.sql.gz /tmp/mythconverg--20130719144734.sql.gz /tmp/mythconverg--20130719151859.sql.gz /tmp/mythconverg--20130719145933.sql.gz /tmp/mythconverg--20130719151130.sql.gz Ten pages of mythconverg files Also at the end of the list Code: -rw-r--r-- 1 mythtv mythtv 786927 Jul 19 14:37 mythtv_ddp_data -rw-r--r-- 1 nobody nobody 0 Jul 19 15:33 oprhan.result -rw-r--r-- 1 root root 486 Jul 19 14:58 remotes.log -rw-r--r-- 1 root root 8945 Jul 19 14:47 systemconfig.log -rw-r--r-- 1 root root 202392 Jul 19 14:47 systemconfig_debug.log drwxr-xr-x 2 mythtv mythtv 4096 Jul 18 21:24 tvdb_api_1000 -rw-r--r-- 1 root root 39 Jul 19 14:46 wrapper.out -rw-r--r-- 1 root root 4006 Jul 19 14:46 xconfig.log That's about it, still stuck |
Author: | mattbatt [ Sun Jul 21, 2013 11:26 pm ] |
Post subject: | Re: Unable to Restore Database |
When I had issues with my database upgrading from 6.02 to 6.04 and on to 7.2 I found the best way was to take my 6.02 database make a brand new clean install of 6.02 in a virtual machine on my Windows box do a partial upgrade and then try to upgrade again from there. Once I had a working 7.2 backup I did a clean install on my LinHES box and restored it. Worked like a charm. |
Author: | RacerX [ Tue Jul 23, 2013 9:53 am ] |
Post subject: | Re: Unable to Restore Database |
Since the database crashed the light went on in the tunnel from jams. Mythconverg contracted (2 copies and half the tables). I'm surprised that it even worked at all this way. Here is an example R7.5 [root@mythsrv 2013-05-23_18-57]# ls -l total 151440 drwxr-xr-x 71 root root 4096 May 23 18:56 etc -rw-r--r-- 1 root root 155060229 May 23 18:57 mythconverg -rw-r--r-- 1 root root 779 May 23 18:57 ncid R7.5 [root@mythsrv 2013-06-10_00-55]# ls -l total 166536 drwxr-xr-x 71 root root 4096 Jun 10 00:47 etc -rw-r--r-- 1 root root 170518793 Jun 10 00:55 mythconverg -rw-r--r-- 1 root root 2023 Jun 10 00:55 ncid [root@mythsrv 2013-06-10_00-55]# R8 [root@mythsrv 2013-07-03_22-23]# ls -l total 87184 -rw-r--r-- 1 root root 44626548 Jul 3 22:23 all_databases drwxrwxr-x 88 root root 8192 Jun 24 12:20 etc -rw-r--r-- 1 root root 2964319 Jul 3 22:23 mysql_table -rw-r--r-- 1 root root 41663006 Jul 3 22:23 mythconverg -rw-r--r-- 1 root root 2018 Jul 3 22:23 ncid drwxr-xr-x 3 root root 23 Jun 8 14:37 pki drwxr-xr-x 4 root root 45 Jun 8 14:37 settings Because the backup is now automatic it took a database crash to discover that the R8 mythconverg databases are squished going forward! So the next question now is what to do? (import, restore, migrate) the working mythconverg from last backup of R7.5 into my currently empty R8.02 and get the schema up to 1299? [root@mythsrv 2013-06-10_00-55]# ls -l total 166536 drwxr-xr-x 71 root root 4096 Jun 10 00:47 etc -rw-r--r-- 1 root root 170518793 Jun 10 00:55 mythconverg -rw-r--r-- 1 root root 2023 Jun 10 00:55 ncid |
Page 2 of 2 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |