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 Spread sheet?
  • 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 above image to start the video tutorial on how to use PHPMyAdmin to import, export or change data in your database table.

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

Found this resource interesting? Subscribe to Tips and Tricks HQ

email icon rss feed icon twitter icon google plus icon

Comments (26 responses)

  1. 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!

  2. Excellent tutorial. Clear, concise and nicely paced. Thank you for the time you spent creating this. :)

  3. Minkmd says:

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

  4. 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.

  5. Marlies says:

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

  6. Nick says:

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

  7. Dean says:

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

  8. Alisha Myers says:

    Excellent tutorial!! This was a huge help!

  9. 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.

  10. Oren says:

    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

  11. 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.

  12. Jay says:

    Would this work with Custom Fields?

  13. 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
    expertise.

  14. 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:)

  15. webseo says:

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

  16. gwen says:

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

  17. admin says:

    Glad to hear that :)

  18. 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.

  19. 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.

  20. Alexis says:

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

  21. 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!

  22. Rachel says:

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

Speak Your Mind

*