| LinHES Forums http://forums.linhes.org/ |
|
| Lost mythconverg in R4V4 auto update http://forums.linhes.org/viewtopic.php?f=1&t=1624 |
Page 1 of 1 |
| Author: | andromeda [ Thu Jun 03, 2004 8:38 am ] |
| Post subject: | Lost mythconverg in R4V4 auto update |
I ran the auto update for R4V4 and installed i686-x. It seemed like everything went fine. But now I'm getting an error that it cannot find the 'mythconverg' database. I looked in MYSQL and sure enough it's not there. And of course I didn't bother to back it up before the update 
Is there another way to get that database? Thanks! |
|
| Author: | Dinki [ Thu Jun 03, 2004 9:19 am ] |
| Post subject: | |
During the autoupdate, the entire contents of hda1 are removed. That's why it's imperative to run 'mythbackup' . Unless you saved an sql dump of your database on a partition that didn't get wiped, I doubt you'll be able to get it back. The good news is that all your data under /myth should still be there. How to associate that data with the database is beyond me though. |
|
| Author: | andromeda [ Thu Jun 03, 2004 7:49 pm ] |
| Post subject: | |
That's what I thought. But I don't mind that I lost all the data in the database. I just want to get the thing working again. Is there a way I can get a sql dump file of just the structure of the mythconverg database or is it not that simple? |
|
| Author: | Xsecrets [ Thu Jun 03, 2004 9:42 pm ] |
| Post subject: | |
if you get the source from the mythtv site it has an sql dump with the structure you can import. |
|
| Author: | reddog [ Fri Jun 04, 2004 7:08 am ] |
| Post subject: | |
All you should need to do is create the database space in mysql: Code: create database mythconverg;
Then, one of the myth peices should automatically create all the tables. I think mythtv-setup will do it when it starts. I've done this before, the only downside is you then need to go in and fix all the various paths to where knoppmyth keeps things (live tv cache, recording path, music path, etc.) |
|
| Author: | andromeda [ Fri Jun 04, 2004 12:51 pm ] |
| Post subject: | |
Thanks for the help! I actually downloaded the mythtv source and found the mc.sql file that creates the mythconverg database. I thought it was going to be a big file but all it contains is: Code: CREATE DATABASE mythconverg;
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; After running that in MYSQL, I was able to load MythTV, start the setup and download all the TV listings from zap2it. Now all I have to do is figure out why the backend isn't running. Argh.... |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|