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<user> -p<password> 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 [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
