Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- vi ~/.my.cnf
- [mysqldump]
- user = root
- password =
- chmod 600 ~/.my.cnf
- crontab -e
- 0 0 * * * mysqldump -u root -h localhost --all-databases | gzip -9 > alldb.sql.gz > /dev/null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement