This guide explains how to back up 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 hosting & website management section in your Infomaniak Manager (❓: help).
2. Click on the name of the website in question.
3. Click on the chevron ‍ to the right of Databases in the left-hand menu.
4. Click on Databases in the left-hand menu.
5. Click on the action menu ⋮ to the right of the relevant item in the table that appears.
6. Click on Export (or on Download a backup):
   
7. Click on the export method and choose the database to download from the drop-down menu.
8. Click on the Next button:
   
9. Click on any desired instructions:
   1. Gzip compression
   2. Drop Table
   3. Create Table if not exists
   4. Insert ignore into
10. Click 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 account (❓: help).
2. Connect to the server via SSH (❓: help).

3. Adapt and run the following SSH command to generate the export:

   # Usage: mysqldump --host=[hostname] -u [username] --password=[password] [database_name] --no-tablespaces > [output_file.sql]
   mysqldump --host=db_host -u db_user --password=db_password db_name --no-tablespaces > backup.sql

4. Wait for the command to complete (the terminal may freeze for a few seconds).

5. From a terminal on your local machine, download the generated file via SCP (❓: help):

   # Usage: scp [username]@[server_ip]:~/[remote_file.sql] [local_path]
   scp user@server_ip:~/backup.sql ./backup.sql

Additional help

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

  # Example with standard credentials
  mysqldump --host=abcd.xyz.infomaniak.com -u abcd_test --password=your_secret_password abcd_test --no-tablespaces > backup.sql

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