Tuesday, September 3, 2019

Mysql Auto backup -schedule data and time

Mysql Auto backup - schedule data and time

touch /opt/backup.sh
nano /opt/backup.sh
mysqldump -u root -p***** Database > /opt/database-`date +%Y-%m-%d_%H-%M-%S`.sql

crontab -e
 0 23 * * * / opt/backup.sh

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)