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 🙂
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)
Thanks a lot for this tutorial, It really helped me out!!!
Thank you very much for this tutorial
@Brian, The phpmyadmin.net site has some documentation that should help you.
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.
@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.
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?
This tutorial was so helpful! Exactly what I needed; I appreciate the step by step presentation and the “what if” scenarios. Thank you!
Excellent tutorial. Clear, concise and nicely paced. Thank you for the time you spent creating this. 🙂
Thanks for nice tutorial. With this tutorial , my database is safe, thanks again!
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.
Thank you, this is much faster than the way I used to import.
Great tutotial – i had thought there might be a wordpress plugin to perform this process but this seems straight forward enough.
Useful video. I always export and import a whole database but never attempted an individual table or tables.
Excellent tutorial!! This was a huge help!
@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.
I installed ‘eStore’ but when looking inside the site’s database I can’t find the theme’s tables…
What am i doing wrong?
Essentially you are directly modifying the value in the database so it will work with anything that is stored in the database table.
Would this work with Custom Fields?
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
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:)
Yes, I just imported it when I switched my hosting from shared to dedicated
Thanks. Sometimes moving blog is necessary. Copying database is very important.
Glad to hear that 🙂
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.
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.
Hi, Thank you for this nice totorial. I am using it with my ecommerce plugin already and having fun 🙂
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!
Fantastic video tutorial on how to import and export any WordPress database content. This will come in really handy.