| LinHES Forums http://forum.linhes.org/ |
|
| mythrestore question http://forum.linhes.org/viewtopic.php?f=21&t=22639 |
Page 1 of 1 |
| Author: | Too Many Secrets [ Fri Jun 01, 2012 12:02 am ] |
| Post subject: | mythrestore question |
So my MBE borked today. I had to do a fresh install, but was able to recover recordings and backups as of a couple days ago. I run the mythrestore command but get to the point below and it just hangs. Any suggestions would be helpful as my-sql-foo is very weak... TIA Code: Completed the restore of files.
Starting the DB restore, this can take a while... Clearing out the existing skeleton... Recreating the db... /usr/LH/bin/mythrestore: line 99: 9611 Done printf "$TEXT" 9612 Killed | osd_cat --lines=6 --pos=middle --align=center --delay=$2 --color=$color --outline=$outline --outlinecolour=$outlinecolour --shadow=$shadow --shadowcolour=$shadowcolour --font=$font (wd: /myth/backup) /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'mythconverg'; database exists' Restoring the data (long)... ^CCtrl-C -- sending "KILL QUERY 350" to server ... Ctrl-C -- query aborted. ERROR 1034 (HY000) at line 1295: 0 for record at pos 22664160 |
|
| Author: | tjc [ Sat Jun 02, 2012 10:38 am ] |
| Post subject: | Re: mythrestore question |
"Hung" for how long? If your DB is really big it can take several minutes to restore, 15 wouldn't shock me, especially if you've got a lot of recordings, videos, or channels in your lineups. Just to get a feel for that, how big is the SQL dump file and how many lines are in it? Code: gzip -dc /myth/backup/mythconverg.sql.gz | wc
|
|
| Author: | Too Many Secrets [ Sat Jun 02, 2012 6:24 pm ] |
| Post subject: | Re: mythrestore question |
Thanks for the info. I don't remember how long I waited, but it was about 30 minutes if iirc. Willing to keep trying if it will help. TIA Code: gzip -dc /myth/backup/mythconverg.sql.gz | wc 4258 2729619 578562232 UPDATE: OK, I ran it again and it left and it ran to completion!!! Thanks!! I must have just not waited long enough. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|