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.

 


Tagged with:

Published by

Be Sociable, Share!