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
- Click the database name on the left.
- Click the Export tab at the top.
- Leave Quick and SQL selected.
- Click Export (or Go). A
.sqlfile 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:
- In phpMyAdmin, click your new, empty database on the left.
- Click the Import tab.
- Click Choose File and select your
.sql(or.sql.gz/.zip) file. - 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.gzfirst. 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.






