[mythtv-users] recordedmarkup table corruption
Robert Tsai
rtsai1111 at comcast.net
Fri Jun 17 17:05:10 UTC 2005
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050617/d5672b9e/attachment.pgp
More information about the mythtv-users
mailing list