How to Import or Export a Database with phpMyAdmin Print

phpMyAdmin provides Import and Export tools for database data.

Export

1. Open phpMyAdmin.
2. Select the database.
3. Choose Export.
4. Select an appropriate export method and format, commonly SQL.
5. Download the export file.

Import

1. Create/select the intended cPanel-managed database first.
2. Open that database in phpMyAdmin.
3. Choose Import.
4. Select the SQL or supported data file.
5. Review the result for errors.

Large imports can exceed PHP or web-request limits. Do not import production data over an existing database unless that overwrite is intentional.