Web Hosting in India Domain Registration India Mumbai Delhi Bangalore Chennai Chandigarh Pune Hyderabad Kolkata Jaipur Lucknow Ranchi Raipur Bhopal Kanpur Bhubaneshwar Kochi Truvantpuram Ranchi Patna Raipur Ajmer Jodhpur Jabalpur Agra Meerut Noida Ghaziabad

Exporting databases and tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin

Now let's learn how to export a database

Click the database you wish to export here



Then click the Export button



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

Be sure to check any options you want before proceeding

Check the Save as File checkbox, then click Go



That's it! The demo1234_members database has been exported to our local computer

If you only wanted to export a table, and not the entire database, follow these steps

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)

That's it! The details table has been exported to its own file

This is the end of the tutorial. You now know how to export databases and tables using phpMyAdmin

Was this answer helpful?

 Print this Article

Also Read

Deleting fields from database tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to delete...

Searching through a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to use the...

Becoming familiar with databases in phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's familiarize ourselves...

Deleting tables from a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to delete a...

Creating tables in a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to create a...

Powered by WHMCompleteSolution