On Tue, Jun 01, 2004 at 09:28:37AM -0400, adam wrote:
>
> mysqldump --user=root --password= --opt bugs >
> $BACKUPDIR$BACKUPSQLFILE
>
> My problem is that it does not seem to work when the crond calls the script.
> The result of the dump is a zero size sql file.
Don't you get the output of stde
Here's a simple python script that I use to do mysql backups. I wrote it
myself. It works great. Cron it to run however you like:
def db_backup():
import os, time
# Change db_list contents to reflect the names of your databases.
db_list = ['c
Hello.
I am using mysql 4.0.18 on rh3, and I would like to daily save db state. I
have this small script
under the cron directory that when executed from the prompt works fine.
Basically the dump is done by:
mysqldump --user=root --password= --opt bugs >
$BACKUPDIR$BACKUPSQLFILE
My