How do I import or export a database with phpMyAdmin?

Open phpMyAdmin in cPanel, choose the database, and use the Import or Export tab.

Export (backup)

1. In cPanel, open Databases → phpMyAdmin.
2. Click the database name on the left, then Export.
3. Keep Quick and SQL selected and click Export. A .sql file downloads.

Import

1. Create an empty database first (see How do I create a MySQL database?).
2. In phpMyAdmin, click the new database, then Import.
3. Choose the .sql file (or .sql.zip / .sql.gz) and click Import.

Tip: Very large databases can time out in the browser. Send us the file through a ticket and we will import it for you.

Still stuck?

Open a support ticket with your domain name and what you see, or message us on WhatsApp. We answer Monday to Friday, 08:00–17:00 Central Africa Time.

Updated 5 November 2026. Something here out of date? Tell us.