Backup all MySQL databases

If you want to backup all of the databases in MySQL you can run the following in the command line (assuming you have create a sqlbackup folder in your home drive):

mysqldump --user=root --password --lock-all-tables --all-databases > ~/sqlbackup/backup.sql

You will be prompted for the password of the MySQL root account