How to Dump All Databases in MySQL Server

To damp all MySQL databases, use the –all-databases option.

mysqldump -u username –p password –all-databases > dump.sql

[Related posts]

How to Backup Only Data of a MySQL Database
For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump...
How to Backup MySQL Databases
There are two methods to backup MySQL, first method is by copying all files such have extentions *.frm, *.MYD, and *.MYI, and second is by...