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

Importing a database

To import a database into Infomaniak:

1. Click here to access the management interface for your product in the Infomaniak Manager (need 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 sidebar.
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. upload your database directly (sql, gz, bz2, zip, 300 MB max) from your computer,
   2. select the file to import from your hosting account after uploading it to the server via FTP,
   3. choose a backup from those that are created automatically.
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

• You must have the .sql file of the database to be imported.
• You must have created a new, empty database.
• You must have a user who has all rights to the database.
• You must have an FTP + SSH account.

To import via SSH:

1. Upload the database to be imported via FTP to your hosting.
2. Open an SSH terminal/console,
3. From a Terminal-type 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@server-address

   • replace ftp-user with the FTP + SSH account username (e.g. abcd_user)
   • replace server-address with the web server address for your hosting
5. Enter the password for the 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 the MySQL server for your hosting
   • 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).