Backups for MySQL With mysqldump (opens in new tab)

Basic Usage mysqldump is a client utility that can be used for doing logical backups. It will generate the necessary SQL statements to reproduce the original database. Backup by Nick Youngson CC BY-SA 3.0 Pix4free The following statements are some common uses of mysqldump: mysqldump -u username -p database_name [table_name] > dump.sql mysqldump -u username -p --databases db1_name db2_name > dump.sql mysqldump -u username -p --all-databases > dump.sql The first example is for backing up a sing...