Backing up All MySQL Databases using mysqldump

Backing-up your sql databases can be done effectively with the mysqldump facility. You will need to login as the MySQL server root administrator. The following command will backup ALL your databases.

mysqldump -u myusername -pmypassword -A > backup.sql

To dump a single database

mysqldump -u myusername -pmypassword databasename > backup.sql