Backup and maintenanceMySQL
mysqldump
Export databases or selected tables to SQL dumps.
Command
mysqldump -u -p > backup.sql
Example usage
Capture consistent backups with stored routines included.
mysqldump -u <user> -p <database> > backup.sqlmysqldump -u <user> -p --databases <db1> <db2> --single-transaction --routines > multi.sqlRelated tags
Backup and maintenancedatabasesqlinnodb