MySQL: Automate MySQL Dump
Need to backup all the databases daily mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p Then edit in home directory a login connection file .mylogin.cnf vi /home/admin/.mylogin.cnf [client] user = root password = "the db password" Limit…