MySQL dump/restore

This is the most convenient way to back up and later restore MySQL database data.

Back up:

mysqldump --user=<username> --password <password> --database <db_name> > <file_name>

Restore:

mysql --verbose --user=<username> --password <password> < <file_name>
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s