This is a guide about creating MySQL backups using mysqldump.
Using mysqldump has the following characteristics:
- Online backup;
- Full backup;
- Selection of databases and tables;
- For both MyISAM and InnoDB tables;
- Can be run remotely;
- Read lock during the dump, unless only InnoDB tables are dumped.
Creating a backup
To create a consistent, full backup, on a database with MyISAM and/or InnoDB tables, use: