PhpMyAdmin Database Backup

How to backup large databases or all databases on your server using just PhpMyAdmin:

1. Click the Export tab

2. Under Export, choose “Select All”

3. Under Structure, only select “Add DROP TABLE”, “Add AUTO_INCREMENT value”, and “Enclose table and field names with backquotes”

4. Under Data, only select “Complete inserts” and “Use hexadecimal for binary fields”

5. Check “Save as file”, choose compression and click GO!