[mythtv-users] Cleaning my DB?

[David Reitz]

On 5/28/10 9:39 AM, Derek Stark wrote:
> 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?
>
> Thanks!
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>    
I just did this myself.  I used the guide I found below.  I found it 
useful, maybe someone else will as well.  Good luck!

http://www.mythpvr.com/mythtv/tips/migrate-recordings.html

Regards,
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100528/8a6a099e/attachment.htm>