Import a website database without overwriting the wrong data Print

Quick answer

Import a database only into the intended target and preserve the current target before replacing anything. A database can contain customer records, credentials, serialized settings, and links to other systems. Treat it as sensitive and reconcile newer production data before a rollback or migration.

Before you start

Confirm the source application, export date, destination database, engine/version compatibility, and whether the import is for staging or production. Obtain a backup of the current destination and a recovery plan.

What to do

1. Inspect the export's purpose and format without uploading it to a public folder or general AI chat. Check whether it includes table-drop statements or a database-selection command.
2. Choose the exact destination in the supported database tool and confirm that it belongs to the intended website.
3. Import through the supported interface or a qualified deployment workflow, accounting for file-size and execution limits.
4. Update environment-specific settings using the application's supported method, then test the site with external side effects disabled on staging.

Check the result

Check table counts, application login, expected content, and critical business records. A completed import message is not proof that the application is connected to that database.

If something does not work

For a partial or timed-out import, stop repeated writes and inspect the state before retrying. Do not replace a live store database with an old export without a plan for newer orders and customer changes.

Use the cPanel database Access denied troubleshooting guide when the import/application reports Access denied. Preserve a partial import and its error before retrying; deleting unrelated tables is not a general import repair.

Related help

• Create a database and a dedicated application user
• Exporting databases and tables with phpMyAdmin
• Preserve new orders and inquiries when planning a restore

Official references

• cPanel Manage My Databases
• cPanel Backup

Reviewed October 31, 2026. Interfaces, vendor availability, and account features can change. Check your current account before making changes.