How do I make a backup of my database?

Follow these steps to make a backup of your database:

  1. Go to phpMyAdmin in the Control Panel of your domain.
  2. Click Databases in the menu
  3. Click the name of the database you want to export, e.g. example_com.
  4. Click Export.
  5. Select Custom - display all possible options.
  6. Select the tables you want to export.
  7. Scroll down and tick the checkbox Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement under Object Creation options.
  8. Click on Go.

The exported tables are now saved to a file called example_com.sql that you can import into another database.