How to Backup & Restore MySQL Database

How to Backup & Restore MySQL Database

Note: This article will be emailed to your friend.

Note: My WordPress database name is wordpress. I will use it in the example below.
It will work for any MySQL database.
(The procedure below will work with any version of WordPress too)

Backup:
mysqldump --opt wordpress | gzip -9 > wordpress.sql.gz
Restore:
gunzip wordpress.sql.gz
mysql -u rootusername -p **** wordpress < wordpress.sql
For detailed usage of mysqldump and mysql commands refer to [...]

Read the rest of this article (94 words)

Please fill in the following fields

* - Required

Your Name: *

Your E-Mail: *

Your Remarks:

Friend's Name: *

Friend's E-Mail: *

Protected by Comment Guard Pro