On Tuesday 19 July 2005 07:30 am, Christian Hack wrote: > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ben Curtis > > > > So I'm running RedHat 9 w/ Myth 0.16. I'm building up a new > > Fedora Core 4 > > box with Myth 0.18. I'd like to rebuild my database from > > scratch (there > > are a couple of issues in my current DB with channels), > > however, I want to > > move over my recordings, scheduled recordings, and previous recording > > listings (so I won't start recording shows I've already recorded). > > > > Can I just use mysqldump to create insert statements for the > > oldrecorded, > > recorded, and record tables, or do I need more data than that? > > Basically all here: > > http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.7 > > Do the dump of old DB and move the files (if necessary). Import the dump > into the new DB
I'd be curious if this works for you. I just did this myself, and ran into a snag. After following the howto and getting a restore.sql file, I couldn't import it because the # of rows didn't match. Some investigation showed that the "record" table has a new field called "parentid" in 0.18.1. Here's what I did. Instead of appending each grep result into the same restore.sql file, I put each one in its own file and imported them individually. "record" is the only table that had a problem, so I opened that up in an editor and added the new field to each row (the last field, setting it to its default 0). Then, I could import the record table. There's probably a better way to do this, but this worked for me. _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
