How to export a MySQL database (download a .sql backup)
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
- Log in to the control panel (
https://<server>:2083). - Open MySQL Databases (section Databases) and click Open phpMyAdmin.
- Click the database on the left.
- Open the Export tab.
- 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.
Thank you — this helps us improve the article.
Still stuck?
Ask the AI about your exact situation — it answers from this knowledge base — or contact us.
Related articles
- How to import a MySQL database (.sql file) and size limits
Import a .sql or compressed .sql.gz backup into a MySQL database with phpMyAdmin (up to 512 MB) or the mysql command over SSH for larger files.
- How to open phpMyAdmin to manage your MySQL databases
Open phpMyAdmin from the control panel with one click, without a database password, on its own port 2097, and what you can and cannot do there.
- How to create a backup job (schedule automatic backups)
Schedule automatic backups of files, databases and email — from every 15 minutes to monthly — with how many copies to keep and where to store them.