Restoring or migrating data.
BEFORE IMPORTING
Drop the existing tables. Importing over existing data produces duplicate key errors on nearly every row and leaves a mixture.
Select all tables, choose Drop from the dropdown, and confirm.
Back up first if the existing data matters.
THE PROCEDURE
- Select the target database.
- Import tab.
- Choose the file.
- Go.
SIZE LIMITS
phpMyAdmin has an upload limit. Large files fail.
Compress the file, which frequently brings it under the limit.
Or use the command line, which has no limit.
Or use cPanel > Backup > Partial Backups, which handles larger files.
IF IT TIMES OUT PARTWAY
Some tables imported and others did not. Drop everything and start again with a different method.
Do not attempt to continue from a partial import.
AFTER IMPORTING
Confirm the table count looks right Update the application configuration if credentials changed Clear caches Test the site
