Mysqldump backup script and crontab error
Posted on 2014-01-10
I've got the following mysqldumb backup scritpt:
mysqldump -u username -pmypass --all-databases > DB.sql
mv DB.sql.gz /home/user/BACKUPS/"$NOW.gz"
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.