[mythtv-users] Mysql cleanup wipe/restore

[MegaDeTH]

To completely purge and start over do this, warning, this will require 
you compeltely re setup myth, everything will be gone, transcoding will 
not work until you setup the recording & transcoding profiles.

on computer running mysql, do the following without quotes.

"mysqldump > mythconverg.sql"   this will backup your current database 
into the file called "mythconverg.sql


"mysql"  starts command line sql interface

"drop database mythconverg;"  wipes out the database

"quit"  exits to prompt

go to mythtv/database

type "mysql < mc.sql"  creates an empty database, and sets permissions.

When you startup your backend, it will automatically build all the 
tables and apply all the patches needed.

Wouldnt hurt to wipe out all your recordings too, and ensure that folder 
is clean.

You'll have to run setup on the backend, and the clients to setup the 
IP's, all that info is stored in tables, doing this will make it a bare 
scratch install!!

If you want to undo this, just drop the database, recreate the database, 
and then run mysql < mythconverg.sql  that'll restore everything



Todd Chisholm wrote:
> Hi All,
> 
> On Fri, 2003-11-28 at 15:14, MegaDeTH wrote:
> 
>>Thanks for the tips bruce.
>>
>>One of the tables I knew I had issues with, was recordedmarkup, I wiped 
>>it, and ran commflagg --all to repopulate.
>>
>>In the recorded table, I updated all the chanid's to the new layout, 
>>hopefully this was the right thing to do, I only had about 25 shows 
>>recorded, so it was pretty easy.
>>
>>I pretty much wiped everything clean, found lots of config problems I 
>>didnt know about, LOTS!!!   If anybody else is having strange display or 
>>recording issues, I would recomend doing a backup, purge, clean install, 
>>and selective restore only the recorded, and redoing all the setup.
>>
>>Everything is working much much better now.
>>
> 
> This is pretty interesting.  I've been having trouble getting
> mythtranscode to work at all.  Could it be that I have a screwed up
> database, from a transition from .11 to .12?  From poking around in the
> code, it certainly seems to be a database issue. Unfortunately, my
> knowledge of mysql is virtually nil.
> 
> I've got a couple of recordings, but nothing that I really care about,
> so I'd be just as happy to blow away the database entirely and start
> over!  So, how would one perform a 'purge'?
> 
> Thanks very much!
> T
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users