How to Easily Import or Export any of Your WordPress Database Table Content

Comments (32 responses)

1. pedro says:

   August 18, 2015 at 5:36 am

   Thanks a lot for this tutorial, It really helped me out!!!
2. Joe says:

   March 26, 2015 at 12:23 am

   Thank you very much for this tutorial
3. admin says:

   January 25, 2015 at 7:07 pm

   @Brian, The phpmyadmin.net site has some documentation that should help you.
4. Brian Collyer says:

   January 25, 2015 at 1:36 pm

   Excellent video! Very concise and easy to follow. Question? Where can I learn about using phpMyAdmin to create simple queries > then export? I need to combine “posts” & “associated comments” Is that easy to do? Thank you for you help.
5. admin says:

   October 5, 2014 at 8:15 pm

   @Amy, Yes. You only need to export and import the content of the wp_posts table. That table will have the ocntent of your blog posts and pages.
6. Amy says:

   October 5, 2014 at 6:29 pm

   Hello and thank you for this video on using phpmyadmin for updating database information. I currently have an old wordpress blog that I need to import post from this old blog into a new wordpress database. I am wondering if there is a way to import just the post data, or will I have to do this manually? For example, uploading the old data of post into phpmyadmin shows a number of tables, but I just want to import the table for posts. Is this possible?
7. CathyS says:

   April 14, 2014 at 8:29 pm

   This tutorial was so helpful! Exactly what I needed; I appreciate the step by step presentation and the “what if” scenarios. Thank you!
8. Denise Traver says:

   May 17, 2013 at 8:51 pm

   Excellent tutorial. Clear, concise and nicely paced. Thank you for the time you spent creating this. 🙂
9. Minkmd says:

   March 24, 2013 at 1:40 pm

   Thanks for nice tutorial. With this tutorial , my database is safe, thanks again!
10. Raid says:

    July 4, 2012 at 11:40 pm

    Thank you for the video. I really needed to know how to transfer data between my WordPress accounts, and I never knew WordPress runs on MySQL. This makes data recovery much easier as I now know I can easily export data to and fro.
11. Marlies says:

    July 4, 2012 at 8:53 am

    Thank you, this is much faster than the way I used to import.
12. Nick says:

    March 22, 2012 at 5:29 am

    Great tutotial – i had thought there might be a wordpress plugin to perform this process but this seems straight forward enough.
13. Dean says:

    March 6, 2012 at 1:12 pm

    Useful video. I always export and import a whole database but never attempted an individual table or tables.
14. Alisha Myers says:

    January 13, 2012 at 12:46 pm

    Excellent tutorial!! This was a huge help!
15. admin says:

    November 26, 2011 at 6:06 pm

    @Oren, WordPress themes usually don’t create database tables so I don’t think there is any database table that you will be able to find for your theme.
16. Oren says:

    November 26, 2011 at 12:49 am

    Hi.
    I installed ‘eStore’ but when looking inside the site’s database I can’t find the theme’s tables…
    What am i doing wrong?

    Thanks 🙂
    Oren
17. admin says:

    September 16, 2011 at 1:34 am

    Essentially you are directly modifying the value in the database so it will work with anything that is stored in the database table.
18. Jay says:

    September 15, 2011 at 10:57 am

    Would this work with Custom Fields?
19. Joan says:

    August 29, 2011 at 9:32 pm

    Boy, am I glad to hav stumbled upon your site! This is a Godsend to me 🙂

    Thank you for the superb video presentation and a phenomenal learning experience. I’ll be a regular visitor from now on. Thank you for sharing your
    expertise.
20. Seocess says:

    August 11, 2011 at 2:18 pm

    Thanks for the tutorial! I must say you´re the first person who could make me see things clear about PHPmyadmin, did not know about that:)
21. webseo says:

    June 16, 2011 at 10:46 pm

    Yes, I just imported it when I switched my hosting from shared to dedicated
22. gwen says:

    June 10, 2011 at 4:17 pm

    Thanks. Sometimes moving blog is necessary. Copying database is very important.
23. admin says:

    June 6, 2011 at 11:33 pm

    Glad to hear that 🙂
24. Cindi says:

    June 6, 2011 at 9:48 pm

    Thank you for such a great product AND for the continual updating without the continual fees. I recommend this plug-in to everyone who will listen.
25. Huy Dam says:

    June 3, 2011 at 10:20 am

    Hi, Thank you very much for the great tutorial (very detail). I have just done exporting my backup for my database. Now I have no worry about my side, my database, it’s safe! Thanks again.
26. Alexis says:

    June 3, 2011 at 9:33 am

    Hi, Thank you for this nice totorial. I am using it with my ecommerce plugin already and having fun 🙂
27. Robert says:

    June 3, 2011 at 2:27 am

    This tutorial is great! I was worried that exporting the database and importing to the new host wouldn’t include all of the pages, comments, etc. So I’ll give this a shot. Thanks again!
28. Rachel says:

    June 3, 2011 at 1:36 am

    Fantastic video tutorial on how to import and export any WordPress database content. This will come in really handy.