Exporting databases and tables with phpMyAdmin

Back to search

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

Also Read

Please explain the meaning of Stats on my Website.
The stats for a website will display as Visits, Unique Visits, Page Views and Hits. They are...
How to create a POP email account in cPanel
This demo assumes you've already logged in to cPanel. Now let's create a new POP email account....
How to install SMF from Softaculous
1 Scroll down until you find SMF in the list on the left. 2 Click SMF. You will be taken to the...
How to install TinyWebGallery from Softaculous
TinyWebGallery is an image gallery. Scroll down until you find it in the menu. 1 Select...