<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
On 5/28/10 9:39 AM, Derek Stark wrote:
<blockquote
cite="mid:AANLkTimogpudDji4UoH08ArBYmm3T3RiAwnu77o6yqEO@mail.gmail.com"
type="cite">Hey all:<br>
<br>
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. <br>
<br>
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?<br>
<br>
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. <br>
<br>
Or should I just punt and export all my recordings out to MythVideo?<br>
<br>
Thanks!<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
I just did this myself. I used the guide I found below. I found it
useful, maybe someone else will as well. Good luck!<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.mythpvr.com/mythtv/tips/migrate-recordings.html">http://www.mythpvr.com/mythtv/tips/migrate-recordings.html</a><br>
<br>
Regards,<br>
David<br>
</body>
</html>