Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
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
- Open the Manager (manager.infomaniak.com)
- Go to Web Hosting
- Click on hosting / the domain name concerned
- In the left-hand side panel, click on Databases
- Click on the icon
to the far right of the database concerned, then select export
- 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:
- If necessary, create a SSH FTP account (find out more)
- Log in to the SSH hosting server (find out more)
- 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 - Wait for the execution of the SSH command to finish (the terminal may freeze for a few seconds)
- Connect to the server using an FTP program (find out more)
- 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
Link to this FAQ: