My configuration for daily backup:
or
or
make a shell script bakup.sh
With all of the methods above my backup.sql file has size of 0 bytes after automatic backup. It's an empty file. Please help me with this problem.
I want to automatically backup MySQL daily.
Code:
#crontab -e
0 0 * * * mysqldump -uroot database > backup.sql
Code:
0 0 * * * /usr/local/bin/mysqldump -uroot database > backup.sql
make a shell script bakup.sh
Code:
#crontab -e
0 0 * * * /bin/sh /shell/bakup.sh
With all of the methods above my backup.sql file has size of 0 bytes after automatic backup. It's an empty file. Please help me with this problem.
I want to automatically backup MySQL daily.