[mythtv-users] running optimize_mythdb.pl on an old version of the database?

David Campbell dave at cpfc.org
Tue Jan 23 08:52:44 UTC 2007


Brad DerManouelian wrote:
> You can log into your MySQL client and run:
> 
> OPTIMIZE TABLE <tablename>
> 
> on all of the tables in your mythconverg database. I haven't looked  
> at the script, but I imagine it's simply looking up the tables in  
> that database and running the MySQL optimize command.

Life is too short.

mysqlcheck -o --all-databases

or

mysqlcheck -o mythconverg
-- 
David Campbell :: www.cpfc.org


More information about the mythtv-users mailing list