Import into the correct empty or prepared database and verify the table count and application behaviour before deleting the source copy.
Applies to: SQL and compressed database exports
Prepare the import
- Create the destination database and assigned user.
- Take a backup if the destination already contains data.
- Confirm the character set, database engine and application version are compatible.
- Keep the source database and export until validation is complete.
Import with phpMyAdmin
- Open Hosting Features > MySQL > phpMyAdmin.
- Select the destination database.
- Open Import.
- Choose the
.sqlor supported compressed export. - Leave character encoding at the export’s correct value, normally UTF-8, unless the source requires another value.
- Start the import and wait for the completion message.
- Check the table list and any reported warnings/errors.
- Update the application configuration with the exact destination database details and test the application.
Common problems
| Symptom | Likely cause | What to do |
|---|---|---|
| Upload/import limit reached. | The export is larger than browser/PHP limits. | Compress the SQL if supported, split it safely, or contact Support for an assisted import. |
| Tables already exist. | The destination is not empty or the import is being repeated. | Stop and compare the destination; do not delete tables without a verified backup. |
| Unknown collation or syntax error. | The source database version or export options are incompatible. | Re-export with compatible options or provide the exact error to Support. |
Related articles
- Create a MariaDB database and user
- Manage a database with phpMyAdmin
- Export a database backup
- Find database connection details
- Restore a database
Last reviewed: 2026-07-25.
