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=root-password --opt bugs

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 =

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=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