mysqldump creates 0 byte sql file from Cron Jobs in cPanel

Question

I have zero bytes sql file (or gz) from this Cron Jobs command in cPanel (only cPanel Cron Jobs):

/usr/local/mysql/bin/mysqldump --user=USERNAME --password=PASSWORD --host=localhost DATABASENAME > /PATH/FILENAME.sql

Many questions checked but nothing found! I check these path for mysqldump:

/usr/mysql/bin/mysqldump
usr/bin/mysqldump
mysqldump

UPDATE: Make .sh file and run that from Cron Jobs. Everythings OK.

#!/bin/bash\
/usr/bin/mysqldump --user=USERNAME --password=PASSWORD --host=localhost DBNAME > /home/CPANELUSER/public_html/FOLDER/FILENAME.sql

Add `2> /tmp/backup-error.log` to the end of the command. That should create an error log with an explanation of the problem. — Michael - sqlbot, Dec 18 '16 at 23:07
@Michael - sqlbot I saw that without error, but write that code into .sh file and run from Cron Jobs ... everythings OK. Thanks a lot — iazaran, Dec 18 '16 at 23:35
Possible duplicate of [PHP regular backup of mysql data](http://stackoverflow.com/questions/38916163/php-regular-backup-of-mysql-data) — e4c5, Dec 19 '16 at 03:06
@e4c5 Only Cron Jobs in cPanel, not PHP codes in website. Thanks again. — iazaran, Dec 19 '16 at 08:56

score 1 · Answer 1 · answered Apr 06 '20 at 14:46

This works for me in BlueHost cPanel: /usr/bin/mysqldump -uUSERNAME -p'PASSWORD' DBNAME > /home4/CPANELUSER/FILENAME_date +\%Y\%m\%d\%H\%M.sql

You can check error by adding this at the end (logs is name of an existing folder):

logs/$(date +"\%Y-\%m-\%d_\%H:\%M").log 2>&1

score 0 · Accepted Answer · answered Dec 19 '16 at 14:40

0

Make .sh file and run that from Cron Jobs. Everythings OK.

#!/bin/bash\
/usr/bin/mysqldump --user=USERNAME --password=PASSWORD --host=localhost DBNAME > /home/CPANELUSER/public_html/FOLDER/FILENAME.sql

answered Dec 19 '16 at 14:40

iazaran

2 Answers2