asked on Mysqldump backup script and crontab error
Hi,
I've got the following mysqldumb backup scritpt:
#/bin/sh
mysqldump -u username -pmypass --all-databases > DB.sql
gzip DB.sql
NOW=$(date +"mysql-backup-%H%M-%d-%m-
mv DB.sql.gz /home/user/BACKUPS/"$NOW.g
It works fine when I start it manually. When i put it in crontab, I get the following error:
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'data\_29'': Got error 28 from storage engine (1030)
I reasearched that error 28 means there is not enough storage. That was the case but i free up some space and I'm still getting this error. Also under crontab the backup file is nearly half the size.
I've got the following mysqldumb backup scritpt:
#/bin/sh
mysqldump -u username -pmypass --all-databases > DB.sql
gzip DB.sql
NOW=$(date +"mysql-backup-%H%M-%d-%m-
mv DB.sql.gz /home/user/BACKUPS/"$NOW.g
It works fine when I start it manually. When i put it in crontab, I get the following error:
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'data\_29'': Got error 28 from storage engine (1030)
I reasearched that error 28 means there is not enough storage. That was the case but i free up some space and I'm still getting this error. Also under crontab the backup file is nearly half the size.
MySQL Server
Last Comment
jackal077
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi,
yes, I must have missed the !. Cron runs under root. I didn't realize I had to define the path inside the script. That was it. Thx.
yes, I must have missed the !. Cron runs under root. I didn't realize I had to define the path inside the script. That was it. Thx.
To take a backup and compress the file in one line of code do this
Open in new window
This will compress your backup as much as possible on the fly and save storage.
Regards,
Tomas Helgi