Import or export a phpMyAdmin database

phpMyAdmin imports and exports MySQL or MariaDB data on your hosting account. Create databases and users through cPanel’s database management tools.

Prepare the operation

Identify the correct database and export a backup before importing into existing data. SQL files can contain statements that replace or delete tables.

Export the database

Open phpMyAdmin from cPanel.
Select the database in the left column.
Open Export.
Choose SQL for a backup intended for re-import. Use Quick for a standard export or Custom to select the required tables and options.
Start the export and store the file privately.

Import an SQL file

Create an empty database and user in cPanel if needed.
Select that database in phpMyAdmin.
Open Import, choose the file and review the options.
Start the operation and read the result message.

If the file is too large

The limit depends on hosting resources, PHP settings and execution time. Check the import screen’s displayed maximum or ask support about an authorized server-side method. There is no universal 250 MB limit.

After import

Check tables, application credentials and important site functions. A successful import does not automatically update the application’s configuration.

Interface illustrations

These screenshots show the versions used when the original article was written. Labels may differ in your current version; follow the written procedure and your account settings.