...

Export databases with phpMyAdmin

Export databases with phpMyAdmin

This tutorial will show you how to export databases with phpMyAdmin

Click the database you wish to export here
Export databases with phpMyAdmin

Then click the Export button
Export databases with phpMyAdmin

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
Export databases with phpMyAdmin

Be sure to check any options you want before proceeding

Check the Save as File checkbox, then click Go
Export databases with phpMyAdmin

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

Previous Post
Deleting tables from a database with phpMyAdmin
Next Post
Databases in phpMyAdmin