MySQL Database Backup with phpMyAdmin
Manual Backup
To backup all databases on a given server:
- Log into the phpMyAdmin web interface on the desired server
- From the top bar select 'Export'
- For a quick backup select 'Quick'
- Then select GO
- For a full backup select Custom
- Press 'Select All'
- check include TimeStamps
- check Include foreign key constraints
- check add CREATE database / USE statements
- Then Select GO
Once file is downloaded, zip and encrypt it, delete the unencrypted file, and move it to the desired backup repository.