phpMyAdmin: Backup and Restore WordPress Database

BACKUP

Backup you database, when ever you update your wordpress installation, you do some work on your theme or just to keep a copy of you data, become familiar with the process of backing up and restoring DB’s.

There are many ways to do a backup, there are even plugins for wordpress that make the job easier, take a look here, but it’s alwasy useful to have an extra ace in your sleves.

With phpMyAdmin it takes few click, first select your wordpress database (you might have more than one DB), click “Export” link, now take a quick look on the “Structure” pane and checkmark “add DROP TABLE”, “add AUTO_INCREMENT value” and “Enclose table and field names with backquotes”.Below “Structure” you can see a section called “DATA” and a checkbox near it, make sure it’s selected, beside that, nothing should be change for the other selections.

In the “Export” pane on the left side you see a box containing all the tables selected for backup, if there are none selected do so, at this point we are almost done, just be sure that the export format is SQL, “Save as file” is marked and pick a compression type, in this case I used “zipped”. Click “Go” and wait, be patient, if you have a lot of posts it might take few minutes.

DB backup videowordpress database backup

You need to upgrade your Flash Player

RESTORE

When you backup data, sooner or later you will need to restore it, nothing easier.As you did for the backup, in phpMyAdmin select your database, this time click “Import” and browse for you backup copy, click “Go” and pra…mmm, wait!

If everything goes well you just restored your database, otherwise you will be notified of any unsuccesful result. If that’s the case google is your best friend.

DB restore videowordpress database restore

You need to upgrade your Flash Player

Thanks for watching

23 comments

  1. Elvira says:

    Very good site you have here but I was curious about if you knew
    of any message boards that cover the same topics talked about in this
    article? I’d really like to be a part of online community where I can get feed-back from other experienced individuals that share the
    same interest. If you have any recommendations, please let me know.

    Kudos!

    Here is my homepage: How to Build a WordPress Blog (Elvira)

    Reply

  2. Dora says:

    As soon as you’ve figured your desired home design and style, start your search for the best home
    accessories in these d. If you are looking to create a traditional French style home you
    will need to think about redecorating, replacing some of your ultra modern furniture and purchasing some new items that
    are in keeping with the French style. Remember that the food will also release its
    own juices.

    My web-site :: tile stove surround

    Reply

  3. We are during working on some sort of institution statement about this matter and your article features served myself while using the facts My spouse and i had to full the idea. Many thanks.

    Reply

  4. phpMyAdmin is pretty similar to some other products I have seen. I wonder what the requirements are regarding patents as it relates to software of this type. Do hosting companies have a site wide license or is it per server installation? Thanks

    Reply

  5. thatgirlagain says:

    Thank you! I was wondering what I was doing wrong (I didn’t have the Drop Table checked) and this saved me an hour of frustration (if not more). Thanks again!

    Reply

  6. TigerTom says:

    Cpanel + Fantastico + WordPress + ‘plugin updating’ plugin = Blog happiness. Update with a few button pushes (in theory). Make a backup before you do so and save in an older version of SQL too in case your new host doesn’t support the latest.

    Reply

  7. Tobias says:

    Hey thanks for the info. I tried to copy my database from oner server to another, but got error messages. After I read your post i clicked the export option “add DROP TABLE” and it worked. So great job and nice videos too.

    Reply

Leave a Reply

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