mysql backup all databases code example

Example 1: export all databases mysql

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

Example 2: backup mysql data only

mysqldump -u testuser -p --no-create-info testdb > /tmp/backup_data_only.sql

Example 3: mysql backup database command line

mysqldump database_name > database_name.sql