On Mon, 7 Mar 2005 [EMAIL PROTECTED] 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
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
