dump mysql one database code example

Example 1: export all databases mysql

# Export
 mysqldump -u root -p --all-databases > all.sql

Example 2: mysql backup database command line

mysqldump database_name > database_name.sql