Work in phpMyAdmin

Print
phpmyadmin, import, export 0

phpMyAdmin lets you look inside your databases, take a copy (export) and load one in (import). This guide covers the two jobs most people need: moving a database, and backing one up by hand.

Updated 19 November 2026Applies to cPanel web hosting

What you'll need

  • A cPanel sign-in for your hosting
  • For an import: the database already created with the Database Wizard, and its .sql file

In cPanel, go to Databases > phpMyAdmin. It opens in a new tab, already signed in. Your databases are listed on the left.

Export (take a copy)

  1. Select the database on the left.
  2. Open the Export tab.
  3. Leave the method on Quick and the format on SQL.
  4. Select Export (in some versions, Go). A .sql file downloads.

Import (load a copy)

  1. Select the database on the left. It should be empty, or one you're happy to overwrite.
  2. Open the Import tab.
  3. Choose your .sql file.
  4. Select Import (in some versions, Go) and wait for the success message.

Big database? phpMyAdmin shows the largest file it accepts beside the file box. A compressed file (.sql.gz or .zip) often fits when the plain one doesn't. If it's still too big, open a ticket.

Look, don't create. Create databases and users in cPanel's Database Wizard, not in phpMyAdmin. Databases made in phpMyAdmin are left out of backups and restores.

What's next

Follows cPanel's documentation: "phpMyAdmin" and "Manage My Databases" (docs.cpanel.net), and phpMyAdmin's own Import and Export screens (November 2026).

Was this guide helpful?

Still stuck?

Send us the details and our team will take it from here

Open Ticket