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.
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)
- Select the database on the left.
- Open the Export tab.
- Leave the method on Quick and the format on SQL.
- Select Export (in some versions, Go). A .sql file downloads.
Import (load a copy)
- Select the database on the left. It should be empty, or one you're happy to overwrite.
- Open the Import tab.
- Choose your .sql file.
- 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
- Create a database and userWith cPanel's Database Wizard
Follows cPanel's documentation: "phpMyAdmin" and "Manage My Databases" (docs.cpanel.net), and phpMyAdmin's own Import and Export screens (November 2026).