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

Export a database via the Manager

To export an Infomaniak database:

1. Click here to access the management of your product on the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the product concerned.
3. Click on Databases in the left sidebar menu.
4. Click on the action menu ⋮ to the right of the object concerned in the table that appears.
5. Click on Export (or on Download a backup):
   
6. Click on the export method and choose the database to download from the drop-down menu.
7. Click on the Next button.
8. Click on any desired instructions:
   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 are unable to export the database via the console or if the database is large:

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

3. Adapt and execute the following SSH command:

   mysqldump --host=votre_serveur_mysql -u votre_user_mysql --password=password_du_user_mysql nom_de_la_base_de_données --no-tablespaces > 	sauvegarde.sql

4. Wait while the SSH command is running (the terminal may freeze for a few seconds).
5. Connect to the server via an FTP software/client.
6. Download the generated SQL file.

Additional help

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

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

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