[mythtv-users] Cleaning my DB?

Derek Stark lemongecko at gmail.com
Fri May 28 13:39:17 UTC 2010

Hey all:

I'm about to move to .23. Notice how I didn't say "upgrade"? I'd like to
clean a lot of things out of my database. I've got a phantom tuner, tuner
IDs in the high teens, settings from old front ends that are gone, etc etc.
The only thing I really want to keep are my recordings.

Does anyone have an idea how I should go about this? Should I do the schema
upgrade & then start blowing records away from tables that offend me?
Attempt to reinsert the recordings into an empty .23 mythconverg?

I am not afraid of the MySQL command-line and have written a few SQL queries
in my day (previous life as a web programmer), but that doesn't mean I'd
know what to do within the MythTV context.

Or should I just punt and export all my recordings out to MythVideo?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100528/b9eb052b/attachment.htm>

More information about the mythtv-users mailing list