Recover or Dump a Mysql databse using a commandline

Posted In: blog |

Backing up MySQL database

mysqldump – a quick way to dump small databases using sql files

One database

All databases

Include routines,triggers and events

Gzip (compress) the backup

Recover:

Recover only one database from the dump file:

Recover from a gzipped file:

Dump everything:

Move one database to a separate file (extract a database from dump containing more than one database:

More on the topic :
http://mysqlserverteam.com/creating-and-restoring-database-backups-with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/
http://mysqlserverteam.com/creating-and-restoring-database-backups-with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/
https://www.lullabot.com/blog/article/mysql-backups-using-lvm-snapshots


Post Tags: mysql |


Comments Off on Recover or Dump a Mysql databse using a commandline