4 Ways to Backup your WordPress Database

WordPress is the leading CMS for blogs and is used by most self-hosted blogs on the Internet these days. Today in this article, am going to talk about a few ways to back up your wordpress database so that if something went bad, you will have sufficient backup files to restore your blog to a previous safe and secure state.

  • database export wordpress

    database export wordpress

    Export from wordpress panel – this is the easiest way to backup a wordpress blog. All you have to do is, login to your wordpress admin panel and navigate to the tools option. In the tools you will find a tab that says export. Click on that and download an xml backup file of your wordpress containing your posts, pages, comments, custom fields, categories, and tags. This is one of the easiest ways to backup wordpress database, and when you need to use the xml backup, just use the import option and wordpress will slowly import everything from the xml backup file.

  • database manager plugin wordpress

    database manager plugin wordpress

    Next option is to backup using a wordpress plugin – wordpress has many utility plugins that provides a wide array of features. One such plugin is, “WP-DBManager”. This is not only for database backups but also have a lot of features, which includes database repair and optimize which has helped me a lot in the past.

  • Back up from the control panel – Your hosting provider gives you a control panel, most likely it will be cpanel, however my host is godaddy and it provides me with a custom panel. If you are a godaddy user then login to your godaddy account. Select the hosting account you want to backup for and then click on – “manage account” next to it. After that click on database and select mysql. From the mysql page click on edit/view details button under the “action” button. That will slide down some options, which will include backup database and restore database.
  • Backup from PhpMyAdmin – Its not that much technical as it sounds, rather it’s a quick way to access and manage database. For backing up a database from phpmyadmin, just click on the “open manager” button on the same page of point number 3. Once you click on the open manager button, it will take you to phpmyadmin page, there you will be first asked for database login details. Once you login, you will enter phpmyadmin. There, simply select the database and click on the export button. Select sql file as backup file and you are done. In the same way for restoring a backup, use the import button.

Note: You will find database and phpmyadmin options in your cpanel as well.

Proper and timely backups will surely make blogging life easy. Remember it takes just a few minutes to make backups and the same few minutes to restore a backup, but if something goes wrong without a backup then it can take ages of manual labor to get your blog to a state, where it was, when it was up and running.

Posted in Blogging Tips Tagged with: , , , , ,
20 comments on “4 Ways to Backup your WordPress Database
  1. Cheapest Domain Name Registration says:

    This is great information on backing up your word press.. There is nothing like losing information.

    • uttoransen says:

      hi Cheapest Domain Name Registration,
      if you put your name in the name field, it will be easy for me to address you,
      anyways, thanks for your comments, glad you like it,

      regards,
      uttoransen,

  2. Nathan says:

    Cheers mate,

    good info here.

  3. uttoransen says:

    hi Nathan,
    thanks for your comments,

  4. Andy Brudtkuhl says:

    Another good database backup is WP-DB-Backup plugin

    http://wordpress.org/extend/plugins/wp-db-backup/

  5. uttoransen says:

    hi Andy Brudtkuhl,
    thanks for your comment,

  6. Jonathan Patterson says:

    We do it the simple way – just go into your dbadmin control panel and export in the default sql format. If you need to view the information inside your database you can export to a word document and search out relevant content.
    Hope this helps –

    Jonathan Patterson
    Patterson Communications

  7. Andy Brudtkuhl says:

    Thought you’d be interested in the plugin we released today – that automagically backs up both your WP files and database to amazon S3. We are backing up our entire network of WP sites with it now – works fantastic. No manual backups and no PHPMYAdmin, etc!

  8. Dana @ Blogging Update says:

    I backup my wordpress database by use export facility, and also use “DB-manager” plugin as second choice.
    .-= Dana @ Blogging Update´s last blog ..The Right Website Design Company Can Help Your Business =-.

  9. warrichpk says:

    if there have any other source or only this one?

  10. Zara Robertson says:

    It is also easy to backup and transfer all your websites from one server to another server if you have cPanel installed:,~

  11. Millie Wood says:

    I have 100 domains on Godaddy and i can say that this company is very reputable.*”:

  12. Robert Affiliate marketer says:

    A cool way of backup the entire data,which is very important if any time the data get corrupted then and then only you can backup your data get the thing easy..

  13. Putra Eka says:

    I usually using wp db backup to backup my wp database daily sent to my email. It help me so much and not worrying anything when something happen to my blog

  14. Jennifer says:

    Thanks for this article – it helped me a lot as a WordPress newbie.

  15. Eapen says:

    Thanks a lot mate, i have been using WP for a long time and I was using a plug-in WP-TimeMachine for backup, now it stopped working. You made my day, i never knew of a Backup option from WP itself that is Tools –> Export. Thanks for showing it to me!

Leave a Reply