The restore that matters most.
FROM JETBACKUP
cPanel > JetBackup > Database Backups. Select the date and restore.
FROM A PARTIAL BACKUP
cPanel > Backup, under Restore a MySQL Database. Upload the archive.
FROM A SQL FILE
- cPanel > phpMyAdmin.
- Select the database.
- Drop the existing tables first. Importing over existing data produces conflicts and partial results.
- Import tab, choose the file, and go.
For large files this times out. Use the command line instead, or ask us.
FROM THE COMMAND LINE
With SSH access, feed the SQL file into the mysql client. No size limit and considerably more reliable for large databases.
AFTERWARDS
Confirm the application's configuration still holds the correct database name, user and password Clear all caches Test the site and the administrator login Check content is as expected
THE CRITICAL POINT
Restoring a database rolls back everything in it. Orders, registrations and content since the backup are gone.
