Backup and restore all MySQL databases

To backup all databases at the same time:

mysqldump –user=[USER] –password=[PASSWORD] –all-databases > [BACKUP_FILENAME]

mysqldump --user=[USER] --password=[PASSWORD] --all-databases > [BACKUP_FILENAME]

To restore a dump (in our case, all databases):

mysql -u [USER] -p < [BACKUP_FILENAME]