[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