How to Easily Import or Export any of Your WordPress Database Content (Video Tutorial)

Categories: Tech Tips, Video Tutorial, Web Development, Wordpress

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 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 or export data from your WordPress table.

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

#1 by Denise Traver on May 17, 2013 - 8:51 pm

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

#2 by Minkmd on March 24, 2013 - 1:40 pm

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

#3 by Raid on July 4, 2012 - 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.

#4 by Marlies on July 4, 2012 - 8:53 am

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

#5 by Nick on March 22, 2012 - 5:29 am

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

#6 by Dean on March 6, 2012 - 1:12 pm

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

#7 by Alisha Myers on January 13, 2012 - 12:46 pm

Excellent tutorial!! This was a huge help!

#8 by admin on November 26, 2011 - 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.

#9 by Oren on November 26, 2011 - 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

#10 by admin on September 16, 2011 - 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.

#11 by Jay on September 15, 2011 - 10:57 am

Would this work with Custom Fields?

#12 by Joan on August 29, 2011 - 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.

#13 by Seocess on August 11, 2011 - 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:)

#14 by webseo on June 16, 2011 - 10:46 pm

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

#15 by gwen on June 10, 2011 - 4:17 pm

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

#16 by admin on June 6, 2011 - 11:33 pm

Glad to hear that

#17 by Cindi on June 6, 2011 - 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.

#18 by Huy Dam on June 3, 2011 - 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.

#19 by Alexis on June 3, 2011 - 9:33 am

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

#20 by Robert on June 3, 2011 - 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!

#21 by Rachel on June 3, 2011 - 1:36 am