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

I get asked a lot of questions on how to import or export data to or from a particular WordPress database table on a regular basis. For example:

  • How can I export all my products details from a particular WordPress plugin to a CSV file?
  • How can I bulk change data in some table?
  • How can I export all the products info from WP eStore plugin to a CSV file?
  • How can I export all my members details from the WordPress membership plugin to a Spreadsheet?
  • How can I export all my affiliates details?
  • How can I export my customer details in a certain way?
  • and so on…

WordPress uses MySQL database and one of the benefits of MySQL database is that you can easily import or export data to and from any MySQL database table. Many people probably do not know that there is a great tool called PHPMyadmin that you can access from your cPanel (most hosting provider will offer cPanel with your hosting account for free).

It is extremely easy to use PHPMyAdmin to do any kind of importing or exporting of data and it is available to you for free. All you really need is a good tutorial that shows you how to use the PHPMyAdmin tool. So we have created a video tutorial that shows how to use PHPMyAdmin. Once you learn to use this tool you will feel like a superman 🙂

Video Tutorial

Click the following image to start the video tutorial on how to use PHPMyAdmin to import, export or change data in your database table.

Export/Import SQL Tables

The following video tutorial will show you how you can export your SQL tables and then import it later.

Please feel free to leave a comment below and let us know if you liked the tutorial or if you have something to add.

Comments (32 responses)

  1. pedro says:

    Thanks a lot for this tutorial, It really helped me out!!!

  2. Joe says:

    Thank you very much for this tutorial

  3. admin says:

    @Brian, The site has some documentation that should help you.

  4. Brian Collyer says:

    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:

    @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:

    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:

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

  8. Excellent tutorial. Clear, concise and nicely paced. Thank you for the time you spent creating this. 🙂

  9. Minkmd says:

    Thanks for nice tutorial. With this tutorial , my database is safe, thanks again!

  10. Raid says:

    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:

    Thank you, this is much faster than the way I used to import.

  12. Nick says:

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

  13. Dean says:

    Useful video. I always export and import a whole database but never attempted an individual table or tables.

  14. Alisha Myers says:

    Excellent tutorial!! This was a huge help!

  15. admin says:

    @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:

    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 🙂

  17. admin says:

    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:

    Would this work with Custom Fields?

  19. Joan says:

    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

  20. Seocess says:

    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:

    Yes, I just imported it when I switched my hosting from shared to dedicated

  22. gwen says:

    Thanks. Sometimes moving blog is necessary. Copying database is very important.

  23. admin says:

    Glad to hear that 🙂

  24. Cindi says:

    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:

    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:

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

  27. Robert says:

    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:

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

Speak Your Mind