Things I can’t remember – Backup MySQL

We used to do a cron job every night that made a copy of the MySQL database. Since we moved to Linode for hosting, we don’t need the cron job, but every once in a while I make a backup of the database and download it to my computer. This is the command I use.

mysqldump -u backup -A --default-character-set=utf8 -e --create-options >/srv/mysql-backup.sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.