II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin
This tutorial assumes you’ve already logged in to phpMyAdmin. 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 check box, 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 select the table you want to export and export just as you would a database.
- Remember that exporting tables only exports the selected tables within a database, whereas exporting a database will export all tables as well the data schema(provided they’re all selected).
- That’s it! The details table has been exported to its own file.