Exporting a database

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

Exporting a Database via the Manager

To export an Infomaniak database:

1. Log in to the Infomaniak Manager (manager.infomaniak.com) from a web browser like Brave or Firefox
2. Click on the icon at the top right of the interface (or navigate through the left side menu, for example)
3. Choose Hosting (universe Web & Domain)
4. Click directly on the name of the relevant object in the displayed table
5. Click on Databases in the left side menu
6. Click on the action menu ⋮ on the right of the relevant object in the displayed table
7. Click on Export (the default options are suitable for most situations)
   

Exporting 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 (learn more)
2. Connect to the hosting server via SSH (learn more)
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 for the SSH command to execute (the terminal may freeze for a few seconds)
5. Connect to the server via FTP software (learn more)
6. Download the generated SQL file

Additional Help

• Example command to be executed in step 3 of the second procedure: mysqldump --host=fhzc.myd.infomaniak.com -u lfcz_test --password=mypassword lfcz_test --no-tablespaces > backup.sql
  
• Get information related to the MySQL server, username, and database password