Exporting Databases and Tables with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to export a database.
  3. Click the database you wish to export here.

    phpma-export-frame03_1

  4. Then click the Export button.

    phpma-export-frame04_1

  5. In this case, we want to export the entire database in SQL format, so we can easily import it later. This is a good way to backup your database.
  6. Be sure to check any options you want before proceeding.

    phpma-export-frame06_1

  7. Check the Save as File checkbox, then click Go.

    phpma-export-frame11_1

  8. That's it! The demo1234_members database has been exported to our local computer.
  9. If you only wanted to export a table, and not the entire database, follow these steps:
  10. Remember that exporting tables only exports the selected tables within a database, whereas exporting a database will export all tables as well (provided they're all selected).
  11. That's it! The details table has been exported to its own file.

 

Be Sociable, Share!

    Published by

    Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support