• Skip to primary navigation
  • Skip to main content

WebGuide4U

Photoshop | WordPress | Webhosting | Web Designing | Discount Coupon

  • Homepage
  • About Us
    • Author
  • Advertise
  • Free WordPress Installation
  • Contact Us
  • Show Search
Hide Search

[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 it’s 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 the 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 in to Cpanel and click on PHPMyAdmin as shown below:

back-up+database+wordpress+phpmyadmin+mysql+sql+wordpress 3.0

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

back-up database manually+wordpress+wprdpress 3.0+wordpress database+mysql+phpmyadmin

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

wordpress+phpmyadmin+troubleshooting+repair+backup

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

back-up database+wordpress+database+manually+webguide4u+mysql

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

back-up+database+wordpress+phpmyadmin+mysql+sql+wordpress 3.0

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

Summary
How-To Back-Up WordPress Database By Using PHPMyAdmin
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”

How-To, Tips and Tricks, Tutorials, Web Hosting, WordPress

Reader Interactions

Comments

  1. iPhone App Development says

    November 1, 2010 at 09:45

    Thanks for the detailed review. When you have a big blog one has to use manual procedure for backups rather than plug ins.

  2. Vivek Parmar says

    November 1, 2010 at 17:38

    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

  3. shk @ Myliteraturetechlife.COM says

    November 1, 2010 at 18:06

    thats my first visit to your website, quite nice collection of tutorials you have for beginners..
    Keep up the good work (Y)

    Cheerz 🙂

  4. Vivek Parmar says

    November 1, 2010 at 23:18

    Welcome to WebGuide4U, thanks you like the tutorials. working hard to provide each and every tutorial which helps to make a better webmaster.
    thanks for kind words

  5. kbharath says

    November 2, 2010 at 10:30

    Great tutorial vivek. i like the way you have explained with use of images its easy to understand.

  6. fareed khan says

    November 2, 2010 at 13:55

    Thank you very much for the tutorial vivek..

  7. Loudable says

    November 2, 2010 at 20:44

    Hey Vivek you have expalined this article in a very nice manner and I appreciate the effort in it. Anyone can understand this article easily and implement on their blog or website.

  8. Vivek Parmar says

    November 2, 2010 at 22:41

    Thanks KBharath, you liked it. Basically the aim of WebGuide4U is to help out bloggers and webmaster so it becomes necessary to explain it in simple manner as i can.

  9. Vivek Parmar says

    November 2, 2010 at 22:43

    Thanks Sushani for the kind words. WebGuide4u is for beginner’s only as i know how much problem faced by a newbie while learning so many things alone. Hope i can offer them everything

  10. Vivek Parmar says

    November 2, 2010 at 22:53

    Thanks Farred, you like the tutorails. Stay tuned to WebGuidUe4u you will get more tutorials

  11. Shashank says

    December 22, 2010 at 09:41

    its good but it wont work when u need to transfer your site from one domain to another in that case What would u suggest Thanks in adv

  12. Vivek Parmar says

    December 22, 2010 at 10:03

    @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

  13. Shashank says

    December 22, 2010 at 10:05

    Thanks a lot for the tip

  14. Vivek Parmar says

    December 22, 2010 at 10:10

    Anytime dear

Leave a Reply

Your email address will not be published. Required fields are marked *

Hit the ground running with a minimalist look. Learn More

WebGuide4U

All rights Reserved. Articles cannot be reproduced without permission from the author© 2025