| How To Backup Your Database Using phpMyAdmin |
|
|
|
First, you need to login to your Cpanel and choose phpMyAdmin under the databases tab. Then on the left side bar, choose the database that you want to backup.
After that, click on the "export" button in the current database header tab like picture below.
Next, click on the "select all" to backup all the database or you can choose which database tree that you want to backup by highlight it with you cursor by simultaneously press the "Ctrl" button
Then, for the backup options, you must check this box - Comments- Structure- Add IF NOT EXISTS- Add AUTO-INCREMENT value - Enclose table and field names with backquotes- Data- Complete inserts- Extend inserts- Use hexadecimal for BLOBFor the drop down box, choose "none" for the SQL compability mode and "insert" for export type like the picture below
Finaly, you can named your backup database by editing the value in the "File name template" and choose your compression type whether "none" for .sql extension, "zipped" for .zip or "gzipped" for .gzip before you click "GO" to start backup process. (click to enlarge) |







