Getting data back.
BEFORE RESTORING
Take a copy of the current state. It contains everything added since the backup, and restoring overwrites it permanently.
Note what will be lost so you can reconcile afterwards.
THE PROCEDURE
- Select the database in phpMyAdmin.
- Select all tables and drop them. Importing over existing data produces conflicts.
- Import tab, choose the file, and go.
FOR LARGE FILES
Use the command line. phpMyAdmin times out and leaves a partial import, which is worse than not starting.
FROM CPANEL PARTIAL BACKUPS
cPanel > Backup has an upload field for restoring a database archive. Simpler, and it handles larger files than phpMyAdmin.
FROM JETBACKUP
Where your plan includes it, select a restore point and restore the database directly.
AFTER RESTORING
Confirm the application configuration still matches the credentials Clear all caches Test the site and the admin login Check the content is as expected
MATCHING FILES AND DATABASE
For a full rollback, restore both from the same date. Mixing dates leaves the application inconsistent.
