[mythtv-users] Sloooow database

Curtis Stanford curtis at stanfordcomputing.com
Tue Jun 10 17:46:06 UTC 2008


On 9-Jun-08, at 10:37 AM, Mache Creeger wrote:

> How about generating a backup and reloading it from the backup. That  
> may clean up some of the cruft.
>
> Here is my backup script as well.
>
> #!/bin/sh
> #Dumps the mythconverg database - daily backup
> DUMPFILE="mythdb_backup.bz2"
> /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /usr/bin/ 
> bzip2 -cq9 > /opt/mythdb/$DUMPFILE
> exit 0

Yah, I may have to try that.

Curtis



More information about the mythtv-users mailing list