Backing up your website database
Before carrying out any sort of major update to a website, be it a platform or plugin update, you need to ensure you have a local backup saved. Once you’ve got this downloaded you can go to town with your work – if everything does go belly up, you can always come back and import your backup.
Instructions
- Log into cPanel
- Go to phpMyAdmin
- Find the database to backup in the left menu
- Click on it
- Click Export from the top menu
- Choose “Custom” radio option
- Scroll down
- Check “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement“
- Click Go
The database backup will now automatically download. Once it’s completed, name it something relevant, like database name followed by the date. FIle it away somewhere safe.