This guide explains how to import a MySQL/MariaDB database to an Infomaniak Web Hosting account.

Importing a database

To import an Infomaniak database:

1. Click here to access your product management interface on the Infomaniak Manager (❓: help).
2. Click directly on the name assigned to the product in question:
   
3. Click on the chevron ‍ to the right of the database menu in the left-hand menu.
4. Click on Databases.
5. Click on the “More actions” button/menu to access different options.
6. Choose Import a database:
   
7. You will then have the following options:
   
   1. Send your database directly (sql, gz, bz2, zip, 300 MB max) from your computer,
   2. Select the file to import from your hosting after uploading it to the server via FTP (❓: help),
   3. Choose a backup from the automatic backups (❓: help).
8. you can also choose:
   
   1. import the data into a new database (creation),
   2. import into an existing database (replacement/overwrite).

Alternative method (SSH - for advanced users)

Prerequisites

• Have the .sql file of the database to be imported.
• Have created a new, empty database (❓: help).
• Have a user who has all rights on the database (❓: help).
• Have an FTP + SSH account (❓: help).

To import via SSH:

1. Upload the database to be imported via FTP to your hosting account (❓: help).
2. Open an SSH terminal/console,
3. From a Terminal application (command-line interface, CLI) on your device, for example the PuTTY application (to be downloaded and installed on Windows) or Terminal (installed by default on macOS), run and adapt the following command:

4. ssh ftp-user@adresse-du-serveur‍

   • Replace ftp-user with the username of your FTP + SSH account (e.g. abcd_user).
   • Replace adresse-du-serveur with the address of your web hosting server (❓: help).
5. Enter the password for your FTP + SSH account.

6. Enter and adapt the following command:

   mysql --verbose -u db-user -p db-name -h db-host < path‍

   • replace db-user with the database username (e.g. abcd_user)
   • replace db-name with the database name (e.g. abcd_sample)
   • replace db-host with your hosting's MySQL server (❓: help)
   • replace path with the path where you uploaded the database in step 1 of this procedure (if you have a single website stored in the default location, the path would be, for example, ~/web/test.sql)
7. Wait for the import to complete (this may take several minutes depending on the size).