How do I make a backup of my database?

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.

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

DBbackup1.png

Step 3 - Click the name of the database you want to export

DBbackup2.png

Step 4 - Click Export

DBbackup3.png

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.

DBbackup4.png

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.

DBbackup5.png

Related articles:

Was this article helpful?

Can’t find what you are looking for?

Start a chat

It's the quickest way to get in touch, every day of the year.

Start chat

Give us a call

Available on weekdays from 10am to 2pm (UTC).

Call +44 20 8106 0910