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!

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.

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?

if you get the source from the mythtv site it has an sql dump with the structure you can import.

All you should need to do is create the database space in mysql:



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.)

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:


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....