How to Backup & Restore MySQL Database
By Angsuman Chakraborty, Gaea News NetworkFriday, May 13, 2005
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 MySQL documentation.
PS. I am aware of the Single click plugin for WordPress. But I don’t trust any WordPress plugin with my database, unless I have fully checked the code 
|
July 16, 2010: 4:07 am
Thanks for another fantastic article. I am always looking for original WordPress tutorials to suggest to my own readers. Thanks for creating this post. It’s just what I was trying to find. Truly phenomenal post. |
 imran |
November 4, 2005: 1:04 pm
Hi I did like your blog postings and comments. I am in big problem since many days. Any kind of help would be appeiciated. I want some help to enter data into mysql databasefrom a flash form using coldfusion components ? i’m using web services and simply want to pass data from my flash form to my cfc while staying in flash… any actionscript (or coldfusion code ‘cfc’) that anyone could provide or even links to other ressources on this specific topic would be awesome… if someone could help me with this process i would be greatful….. thank you in advance… Imran Hashmi |
Carol