[mythtv-users] Sloooow database

[Curtis Stanford]

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