On March 14, 2005 11:54 pm, Brad Benson wrote: > On Mon, 14 Mar 2005 17:30:43 -0400, Mark J. Small <[EMAIL PROTECTED]> wrote: > > I recently had a messy incident on my mythtv backend after my hard disk > > filled up. > > > > Now somehow my settings table has gotten completely hosed. When I look > > at the database with mysql-query-browser, it can not fetch the columns > > for the table settings. > > > > When I try to run mythfrontend, I get this: > > > > 2005-03-14 17:30:00.043 Told to create a NEW database schema, but the > > database already has 55 tables. > > If you are sure this is a good mythtv database, verify > > that the settings table has the DBSchemaVer variable. > > > > 2005-03-14 17:30:00.043 Couldn't upgrade database to new schema, exiting. > > > > I have a backup from just before I upgraded to 0.17. > > > > What can I do? > > > > Mark > > > > > > _______________________________________________ > > mythtv-users mailing list > > mythtv-users@mythtv.org > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > My first suggestion would be to make a back up of your current db then > drop the mythconverg database and run mythtvsetup. You'll probably > want to tell mythtvsetup to clear all settings for tuners and > channels. I believe that running mythtvsetup should setup the > mythconverg database for you. If not then it should get setup the > first time you start the backend or frontend. Of course, any settings > you've changed recently will have to be changed back as all the > default settings will be inserted when the db is recreated. > > As long as you make a backup of your current db before you do this you > can always roll it back to your currently hosed version and try some > other method if this doesn't work, but I expect this should get you > fixed up and ready to run again. > > Brad
Thanks for the reply, I ended up doing things a little more easily. First I backed up the database for safety's sake. Then I ran mysqlcheck and got it to fix the broken tables. Everything looks good now. Mark _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users