Database Restore Errors (Common Messages and Fixes) Print

Database Restore Errors (Common Messages and Fixes)

1. If import fails in phpMyAdmin:

   1. Try compressed .sql.gz export/import.

2. If you see “max execution time” or timeouts:

   1. Import during low traffic.

   2. Split the SQL file (advanced) or request assistance.

3. If you see collation/charset errors:

   1. Export using compatible settings.

   2. Ensure the database charset matches the site requirements.

4. If tables already exist:

   1. Ensure the export includes DROP TABLE statements (or delete tables before import if you know what you’re doing).

5. If the website breaks after DB restore:

   1. Confirm wp-config.php points to the correct database/user.

   2. Clear cache.

6. Best practice

   1. When unsure, request a full restore instead of manual DB operations—manual DB changes are easy to misapply.