Re: mysqldump under cron

2004-06-01 Thread Chris Elsworth
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

Re: mysqldump under cron

2004-06-01 Thread Brad Tilley
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

mysqldump under cron

2004-06-01 Thread adam
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