How To Make WordPress Database Backup Using MySQL

by Himanshu on December 10, 2009 · 12 comments

Wordpress files are important assets of Wordpress bloggers. No one want to lose any files at any cost. To save those files in your locker, you need to take an immediate backup of all your Wordpress file. You can take a backup without use of any Wordpress plugin. So it is good to make a backup without use of any plugin. It save lots of space.

Since most of the bloggers use cpanel in the hosting system, it is so easy to use cpanel to take a database backup.  Here is a step by step process:

1) Login into cpanel.

2) Go to PhPMyadmin

cpanel thumb How To Make WordPress Database Backup Using MySQL

3) In PhPMyadmin click on Export button.

PhPMyadmin thumb How To Make WordPress Database Backup Using MySQL

export thumb How To Make WordPress Database Backup Using MySQL

4) Select gzipped option and click on the go button.

gzipped thumb How To Make WordPress Database Backup Using MySQL

That’s all, your download will start immediately. So backup your database now and feel tension free. This main advantage of this method is that it can executed without any plugin.

Related posts:

  1. Optimize your Wordpress Database With the help of WP-Optimize Wordpress Plugin
  2. How To Install Wordpress (Step By Step Guide of Wordpress Installation)
  3. Secure Your Wordpress By Installing WordPress File Monitor Plugin
  4. How To Restrict Wordpress Admin Use By IP Address
  5. 5 reasons why Wordpress plugins can cause major harm to your blog

Tagged as: Backup, database, MySQL, Plugin, Wordpress

8 Tweets

{ 12 comments… read them below or add one }

1 Vaibhav Kanwal December 10, 2009 at 9:06 pm

Nice tutorial Himanshu, no matter which Web Host you are PHP Admin understanding always comes in handy. At times when WordPress is not accessible due to various reasons.

Import/Export using PHPMyAdmin is the only option available, I am sure your readers will find this useful
.-= Vaibhav Kanwal´s last blog ..Christmas Bonanza – [WIN] Wordpress Blog SetUp + Theme Customization + SEO Worth $350 =-.

Reply   More from author

2 Shivaraj December 10, 2009 at 10:59 pm

In the online world nothing is safe.Day to day backeup is need for smooth running of blog.
Nice tip… :)

Reply   More from author

3 Arafat Hossain Piyada December 11, 2009 at 7:04 pm

Well nice tutorial, I think using backup feature on cPanel is lot more easy.
.-= Arafat Hossain Piyada´s last blog ..Grab FILEminimizer Pictures 2.0 With Free Genuine License Key =-.

Reply   More from author

4 MostlyBlog December 11, 2009 at 8:04 pm

Backup is most important in blogging , nice tutorial himanshu
.-= MostlyBlog´s last blog ..How To Disable or Uninstall A Google Chrome Extension or Addon =-.

Reply   More from author

Leave a Comment

Additional comments powered by BackType

Previous post:

Next post:

©2009 BlogTechnika | Sitemap