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

Export a database via the Manager

To export an Infomaniak database:

1. Click here to access the management of your product on the Manager Infomaniak (need help?).
2. Click directly on the name assigned to the relevant product.
3. Click on Databases in the left sidebar.
4. Click on the action menu ⋮ to the right of the relevant item in the displayed table.
5. Click on Export (or on Download a backup):
   
6. Click on the export method and select 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 FTP SSH account.
2. Log in to the server via SSH (need help?).

3. Adapt and run 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 being executed (the terminal may freeze for a few seconds).
5. Log in to the server via an FTP software/client.
6. Download the generated SQL file.

Additional help

• Example 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.