Import / export databases

You can export or import your database via phpMyAdmin or via a terminal (if your SSH is active).

IN THIS ARTICLE

Export / import database via PhpMYadmin

You can open phpMyAdmin via the control panel. View our step-by-step plan

Export database in phpMyAdmin

  1. Select the name of the database at the very top left of the margin. This takes the form ID <customer number> _ database name, for example: ID132956_wordpress.
  2. Go to the horizontal menu at the top. Click on the “Export” button.
  3. The export method (“Fast”) and the export format (“SQL”) are set correctly by default normally (see image).
  4. Click on the “Start” button to confirm. A .sql file will be downloaded to your computer.

Export method

 

Import database into phpMyAdmin

  1. Go to the horizontal menu at the top. Click on the “Import” button.
  2. Click on the “Choose File” button and browse your device for the desired .sql file (see image).
  3. Click on the “Start” button at the bottom to confirm the import.

File to import

TIP: if you are importing a complete database, the database into which you are going to import the .sql file must be empty.

If, for example, you want to restore a backup of your database, first clear the database by checking all tables in PhpMyAdmin and choosing below for the “drop” action with the selected tables. Repeat this as often as necessary until all tables are gone. Afterwards you can import the .sql file.

Export/import database via Terminal

You can also import/export your database via a Terminal. For this you first have to check if SSH is active and you can easily register – preferably via your SSH key .

Export database via Terminal

To export your database via the Terminal or Windows SSH client, connect to the server and execute the command below, where:

  • HOST: your database must be host
  • USER: your username is from the database
  • PASS: your password is from the database
  • NAME: the name is of the database
  • DUMP.SQL: the name that you want to give the file

Command:

mysqldump -hHOST -uUSER –p'PASS’ NAME > DUMP.SQL

Example:

    mysqldump –hmysql111.hosting.webhosting.be -uID111111_sufix –p’$tr0ngPa$$word’ ID111111_sufix > dump.sql

 

Tip: The file will be saved in the folder where you execute the command.
You can add the file to an internal / www / folder and then download it through your browser. If you do the latter, you should certainly not forget to delete that file as soon as possible afterwards, because there is a danger that you will give others access to your data. [/ Ht_message]

Import database via Terminal

To import your database via the Terminal or Windows SSH client, connect to the server and execute the command below, where:

  • HOST: your database must be host
  • USER: your username is from the database
  • PASS: your password is from the database
  • NAME: the name is of the database
  • DUMP.SQL: the name of the file that you want to import

Command:

mysql -hHOST -uUSER –p’PASS’ NAME < DUMP.SQL

Example:

    mysql –hmysql111.hosting.webhosting.be -uID111111_sufix –p$tr0ngPa$$word ID111111_s
Updated on 20 May 2020

Was this article helpful?

Related Articles