Export a MySQL database

This guide explains how to save or export a MySQL database using the admin console or SSH.

Export a MySQL database using the Manager

1. Open the Manager (manager.infomaniak.com)
2. Go to Web Hosting
3. Click on hosting / the domain name concerned
4. In the left-hand side panel, click on Databases
5. Click on the iconto the far right of the database concerned, then select export
6. Click on Export (the default options are suitable for most situations)

Export a MySQL database using SSH

If you cannot export the database using the console, or if the database is very large:

1. If necessary, create a SSH FTP account (find out more)
2. Log in to the SSH hosting server (find out more)
3. Adapt and execute the following SSH command:
   mysqldump --host=your_server_mysql -u your_mysql_user --password=mysql_user_password data_base_name --no-tablespaces > backup.sql
   
4. Wait for the execution of the SSH command to finish (the terminal may freeze for a few seconds)
5. Connect to the server using an FTP program (find out more)
6. Download the generated SQL file

Additional support

• Here is an example of the command to be executed in step 3 of the second procedure:
  mysqldump --host=lfcz.myd.infomaniak.com -u lfcz_test --password=mypassword lfcz_test no-tablespaces
   > backup.sql
• To find information linked to the MySQL server and the MySQL database user name and password: https://faq.infomaniak.com/1981