If your website uses a database, it is important to keep a backup. In this guide we explain how to export your database and save a copy of it on your computer.
- Step 1 - Open your database in phpMyAdmin
- Step 2 - Click Databases in the top-menu
- Step 3 - Click the name of the database you want to export
- Step 4 - Click Export
- Step 5 - Select Custom - display all possible options and select the tables you want to export
- Step 6 - Scroll down to Object creation options
- Step 7 - Scroll down and click Export
Don't have any hosting yet? With our fast and reliable web hosting, you can turn your website idea into reality.
Step 1 - Open your database in phpMyAdmin
Read our guide on how to access your database if you don't know how to do this.
Step 2 - Click Databases in the top menu
Step 3 - Click the name of the database you want to export
Step 4 - Click Export
Step 5 - Select Custom - display all possible options and select the tables you want to export
All tables are selected by default. We recommend you to keep this.
Step 6 - Scroll down to Object creation options
Under Object creation options activate the slider for Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement.
Step 7 - Scroll down and click Export
The exported tables are now saved to a file, in this example called one_example_com.sql. You can import this to your database when needed.
Related articles: