Export a database

This guide explains how to back up or export a MySQL/MariaDB database via the Infomaniak Manager or SSH.

Export a database via the Manager

To export an Infomaniak database:

1. Click here to access your product management in the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the relevant product.
3. Click on Databases in the left-hand menu.
4. Click on the action menu ⋮ to the right of the relevant object in the displayed table.
5. Click on Export (or on Download a backup):
   
6. Click on the export method and choose the database to download from the dropdown menu.
7. Click on the Next button.
8. Click on the desired instructions, if any:
   1. Compression Gzip
   2. Drop Table
   3. Create Table if not exists
   4. Insert ignore into
9. Click on the Export button.

Export a database via SSH

If you cannot export the database via the console or the database is large:

1. If necessary, create an FTP SSH account.
2. Connect to the server via SSH (need help?).

3. Adapt and execute the following SSH command:

   mysqldump --host=your_mysql_server -u your_mysql_user --password=your_mysql_user_password database_name --no-tablespaces > backup.sql

4. Wait during the execution of the SSH command (the terminal may freeze for a few seconds).
5. Log in to the server via an FTP client/software.
6. Download the generated SQL file.

Additional help

• Example of a command to execute in step 3 of the second procedure:

  mysqldump --host=fhzc.myd.infomaniak.com -u lfcz_test --password=mypassword lfcz_test --no-tablespaces > backup.sql

• Refer to this other guide if you are looking for information related to the MySQL server, username, and database password.