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