How to export a MySQL database (download a .sql backup)

For hosting customers · Updated 2026-10-29

On this page
  1. Export with phpMyAdmin
  2. Export over SSH (large databases)
  3. Good to know
  4. Common questions

An export is a .sql file with all tables and data of a database. Use it to keep a copy, move the site to another server, or work on a copy at home.

Export with phpMyAdmin

  1. Log in to the control panel (https://<server>:2083).
  2. Open MySQL Databases (section Databases) and click Open phpMyAdmin.
  3. Click the database on the left.
  4. Open the Export tab.
  5. Keep Quick and the format SQL, then click Export (in some versions Go).

The browser downloads username_shop.sql. For large databases choose Custom and set compression to gzipped to get a smaller .sql.gz file.

Export over SSH (large databases)

If your plan has shell access, open Terminal or connect with SSH and run:

mysqldump -u username_shop -p --single-transaction username_shop | gzip > ~/username_shop.sql.gz

Enter the user's password when asked, then download the file with the File Manager or SFTP. Delete it from the server afterwards.

Good to know

  • An export is a snapshot of the moment you made it. A full copy of your account, databases included, is made with Create backup on the Backups page (section Advanced). Server administrators schedule automatic copies with backup jobs.
  • Exports and dump files left in your home count toward your disk space.
  • To export a PostgreSQL database, use Export (SQL) in its tool: see PostgreSQL database tool.

Common questions

The download stops for a very large database. What can I do?

Use the gzipped export, or mysqldump over SSH, which has no browser time limit.

Can I export only some tables?

Yes. On the Export tab choose Custom and select the tables.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.