Re: [mythtv-users] recordedmarkup table corruption
On Thu, Apr 28, 2005 at 07:39:47PM -0700, Chris Petersen wrote: > Since I've posted this everywhere else (and probably here before, too), > feel free to take a look at this: > > http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt > > It loads the mysql.txt file from your mythtv installation, connects > to mysql, and repairs and optimizes ALL of the tables. Add it to a > daily cron job and you'll not only be assured of your tables being > repaired if you're not there to watch them, but it'll keep your disk > space optimized (the recordedmarkup and program tables are > especially good at growing larger than the data they store). Isn't it simpler to just say: mysqlcheck -r -o -u -p mythconverg ? You can script out the user/password/dbname from mysql.txt, but my point is about using the already-existing mysqlcheck program instead of all the perl ... --Rob signature.asc Description: Digital signature ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
On Thu, Apr 28, 2005 at 07:39:47PM -0700, Chris Petersen wrote: > Since I've posted this everywhere else (and probably here before, > too), feel free to take a look at this: > > http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt > > It loads the mysql.txt file from your mythtv installation, connects > to mysql, and repairs and optimizes ALL of the tables. Add it to a > daily cron job and you'll not only be assured of your tables being > repaired if you're not there to watch them, but it'll keep your disk > space optimized (the recordedmarkup and program tables are > especially good at growing larger than the data they store). Why not just incorporate this into the built-in myth timer stuff (a la the internally-scheduled mythfilldatabase)? --Rob ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
Since I've posted this everywhere else (and probably here before, too), feel free to take a look at this: http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt It loads the mysql.txt file from your mythtv installation, connects to mysql, and repairs and optimizes ALL of the tables. Add it to a daily cron job and you'll not only be assured of your tables being repaired if you're not there to watch them, but it'll keep your disk space optimized (the recordedmarkup and program tables are especially good at growing larger than the data they store). -Chris ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
Preet Khalsa wrote: I had a hard lockup on the backend. Froze the entire machine. My reiserfs file system recovered much, but left the table recordedmarkup corrupt. This meant that nuvexport would not run and spits out ... Can't open file: 'recordedmarkup.MYD'. (errno: 145) I checked /var/lib/mysql/mythconverg and it is there. So the table is corrupt. To fix this, log into mysql ... mysql -u root -p mythconverg and then check and repair the table ... check table recordedmarkup; repair table recordedmarkup; And then all should be well. I am posting this because google resulted in nothing useful. Google: mysql errno 145 site:mysql.com Result #5: http://dev.mysql.com/doc/mysql/en/repair.html (How to Repair Tables) Always good to remember that mythtv relies on the health of external programs and they often have excellent resources to diagnose problems with them Kevin ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
Hello, Preet Khalsa wrote: Or just 'mysqlcheck mythconverg'... Ohh I like that one. Very interesting reading. I didn't realize that I had more than one table corrupted. Thanks !!! It is always a good idea to check the entire db after a crash. Regards, Cecil ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
> Or just 'mysqlcheck mythconverg'... Ohh I like that one. Very interesting reading. I didn't realize that I had more than one table corrupted. Thanks !!! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] recordedmarkup table corruption
On 4/28/05, Preet Khalsa <[EMAIL PROTECTED]> wrote: > To fix this, log into mysql ... > > mysql -u root -p mythconverg > > and then check and repair the table ... > > check table recordedmarkup; > repair table recordedmarkup; Or just 'mysqlcheck mythconverg'... ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users