[mythtv-users] Reinstall for .17

[John Patrick Poet]

On Mon, 7 Mar 2005 mythtv at nosolutions.com wrote:

>
> Long time user, about to upgrade to .17 by compiling source (as I always
> do).  However, I have a problem where my my database is "semi" corrupt.  I
> can't explain how, but I have random channels that display twice in my
> guide, and recordings I can't remove.
>
> So, is there a way that I can display a listing off all the recordings I
> have setup in a visible manner other than pulling raw data from the
> recording table so I can reset them all up?
>
> And is there a way I can dump my database but save all my settings like
> the capture card and bitrates/etc?  Maybe by dumping certain tables?
>
> Thanks,
> Ben
>
>

Do something like:

mysqldump -p mythconverg > mythconverg.20050307

That will create an text dump of your entire mythconverg database.  That
text file contains all the mysql commands necessary to rebuild the database.
You can then go in with emacs (or some other editor) and edit that file.

Once you have "fixed up" that file, you could use it to build a new
mythconverg database.  You would first need to "drop" the existing instance
of the DB, and then create a new empty instance.  Once the empty instance
exists, you can do something like:

mysql -p mythconverg < mythconverg.20050307

To reload all the data.

Take a look here:

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5


John