• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Tips and Tricks HQ

  • Home
  • Projects
    • All Projects
    • Simple WP Shopping Cart
    • WP Express Checkout Plugin
    • Accept Stripe Payments
    • WP Download Monitor
    • Easy HTTPS Redirection
    • WP Security and Firewall Plugin
    • WP eStore Plugin
    • WP Affiliate Platform
    • WP eMember
  • Products
    • All Products
    • Checkout
  • Support
    • Support Portal
    • Customer Only Forum
    • WP eStore Documentation
    • WP Affiliate Software Documentation
    • WP eMember Documentation
  • Contact

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

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

Last updated: July 4, 2019





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.

Related Posts

  • How to import WordPress SQL database backup file without having ‘create new database’ privileges in phpMyAdmin
  • How to Uninstall and Reinstall WordPress
  • How to Fix ‘Unable to create directory’ error when uploading image into WordPress
  • Database Recovery Techniques

Tech Tips,  Video Tutorial,  Web Development,  Wordpress Database,  database import,  Membership,  PHP,  Video Tutorial,  Wordpress,  WordPress Membership

Reader Interactions

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Featured & Popular Articles

Video Answers to Top WordPress QuestionsWordPress Optimization Tips and Tricks for Better Performance and SpeedEssential WordPress Security Tips - Is Your Blog Protected?WordPress Simple PayPal Shopping Cart PluginTop 15 Search Engine Optimization (SEO) Techniques I Forget to DoList of the Best and Must Use WordPress PluginsHow do I Start a Blog and Make Money Online?Good Domain Name Picking Tips for Your Blog SetupFind Out Which WordPress Web Hosting Company Offers the Cheapest and Reliable Web Hosting Solution

Featured WordPress Plugins

WP Express Checkout Plugin
wordpress estore plugin
wordpress membership plugin
wordpress affiliate plugin

Recent Posts

  • How to Use Browser Developer Tools to Inspect Elements and [...]
  • Accept Donations via PayPal from Your WordPress Site Easil [...]
  • Buy Now Button Graphics for eCommerce Websites [...]
  • Subscription Button Graphics for eCommerce Websites [...]
  • Adding PayPal Payment Buttons to Your WordPress Sidebar Ea [...]

Comment & Socialize

  • @Rob, We have just released ...
    - admin
  • I installed the plugin a co ...
    - Rob
  • @Sebastian, We've released ...
    - admin
  • I've used this plugin on a ...
    - Sebastian Djupsjöbacka
  • @John, this plugin doesn't ...
    - admin

Check out our solutions

View our WordPress plugin collection and start using them on your site.

Our WordPress Solutions

Footer

Company

  • About
  • Privacy Policy
  • Terms and Conditions
  • Affiliate Login

Top WordPress Plugins

  • Simple Shopping Cart
  • PayPal Donations
  • WP Express Checkout
  • WP eStore
  • WP eMember

Blogging Tips

  • How to Start a Blog
  • Selecting a Good Domain
  • Cheap WP Hosting
  • WP Video Tutorials
  • Simple SEO Tips

Search


Keep In Touch

Copyright © 2025 | Tips and Tricks HQ