Knowledgebase article

How to import and export a database with phpMyAdmin

phpMyAdmin is the window into your databases. With it, you can move a database from your old host to Romeo, take a quick copy before a big update, or peek at your tables.

Open phpMyAdmin

Log in to cPanel and click Databases > phpMyAdmin. It opens in a new tab, already logged in. Your databases are listed on the left.

Export (download) a database

  1. Click the database name on the left.
  2. Click the Export tab at the top.
  3. Leave Quick and SQL selected.
  4. Click Export (or Go). A .sql file downloads to your computer.

Import (upload) a database

First, create an empty database and user in cPanel (see How to create a MySQL database and user in cPanel). Then:

  1. In phpMyAdmin, click your new, empty database on the left.
  2. Click the Import tab.
  3. Click Choose File and select your .sql (or .sql.gz / .zip) file.
  4. Scroll down and click Import (or Go).

When you see a green success message, your memories have moved in.

Troubleshooting

  • "No database selected": click the database on the left before the Import tab.
  • File too large: compress it to .sql.gz first. If it's still too big, Romeo can import it for you; just open a ticket and send a download link.
  • "Table already exists": you're importing into a database that isn't empty. Drop the old tables first or use a new database.

Romeo's tip: After importing a WordPress database, update the database name, user and password in wp-config.php.

Careful: the Drop and Empty buttons in phpMyAdmin delete data immediately. Always export first.

Was this answer helpful?

Related articles

Still stuck? Romeo's got you.
Our support team replies around the clock, real humans who know your server.