View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 6 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu Jun 03, 2004 8:38 am 
Offline
Joined: Thu Jun 03, 2004 8:32 am
Posts: 7
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!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 03, 2004 9:19 am 
Offline
Joined: Fri Dec 26, 2003 2:25 pm
Posts: 244
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 03, 2004 7:49 pm 
Offline
Joined: Thu Jun 03, 2004 8:32 am
Posts: 7
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?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 03, 2004 9:42 pm 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
if you get the source from the mythtv site it has an sql dump with the structure you can import.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 04, 2004 7:08 am 
Offline
Joined: Sun May 23, 2004 5:29 pm
Posts: 5
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.)


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 04, 2004 12:51 pm 
Offline
Joined: Thu Jun 03, 2004 8:32 am
Posts: 7
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....


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu