ldump --all-databases -u root > AllData.txt
> /usr/bin/gzip -c /backups/mysql_backup.gz < AllData.txt
>
> -Original Message-
> From: FMGreen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 04, 2007 11:52 AM
> To: mysql@lists.mysql.com
> Subject: mysqldump (in crontab)
I use the mysqldump command (as below) in crontab to do a dump of my database
each night. Up until last week this was working fine. Last week (when I
was out of the office) there was a problem with the db and a colleague of
mine had to do a manual dump. When he tried to run mysqldump (using the