[How-To Guide] Back-Up WordPress Database By Using PHPMyAdmin

WordPress Blog’s use MySQL Database to store whole information like your blog posts, comments, etc. If you’re a Professional Blogger then you’re constantly updating your blog with at least 4 blog posts a day and this data directly stored in MySQL database which you don’t want to lose at any condition, so its necessary for you to keep up the regular backups of your data to protect it from any loss or damage. Already I had covered a lot on database from installing to deleting a database by using PHPMyAdmin. Now, this post focus on “how-to back-up the WordPress Database By Using PHPMyAdmin”.

Step1: Login into cpanel and click on PHPMyAdmin as shown below:

Step2: Now select WordPress Database and click on “Export” button as shown below:

Step3: Now click on “Select All” to choose all the tables which located in database.

Step4: Now click on SQL option on right hand side and save the file locally, you can choose the compression type and after choosing out click on “Go” button to download it locally on your PC.

Step5: As soon as you click on “Go” button, the browser will ask you to download the back-up. Select “Yes” to download or “No” not to download it.

Do share your ideas how you back-up your wordpress blog. And, if you face any problem, then do let us know in the comments section?

Summary

Article Name

How-To Back-Up WordPress Database By Using PHPMyAdmin

Description

WordPress Blog’s use MySQL Database to store whole information like your blog posts, comments, etc. and this post focus on “how-to back-up the WordPress Database By Using PHPMyAdmin”

glad you like the detailed review. WebGuide4U focus on providing step-by-step guide on tutorials so that a beginner will become a better webmaster. Stay tuned to WebGuide4U we have more to say, yet our best has to come

@Shashank: first back-up your site and download that data by using any ftp client (i prefer filezilla), and upload it the second way is that use a better hosting company (i prefer hostgator) they will do all the things for you without messing up anything the third way is that i will come up with an article on this 🙂 Still not publish the manual installation of wordpress – in new year your wish get fulfilled