How to run mysqldump command

Backup a single database:

Run from your terminal window to get a database dump:

mysqldump -u username -ppassword database_name > dump.sql

Backup all available databases:

Run from your terminal window to get dump of all databases:

mysqldump -u username -ppassword -all-databases > dump.sql

Please note, that all databases in the example above will be dumped as a single file.