How to make a Database Backup (also known as exporting a db) using the MySQL Database Administration Tool phpMyAdmin v2.8.0.2.
Open phpMyAdmin.
Click on the database from the left column. If you have more than one database, then select the database from the drop menu.
After the page opens, click on the Export tab on the top horizontal menu.
After the page opens, on the Export Box select all.
Right underneath make sure SQL is selected.
- (If you are migrating from local to remote installation then follow the instructions in red, otherwise skip it.)
In SQL export compatibility: select - MySQL40
- NOTE Some earlier versions of phpMyAdmin do not have this SQL export compatibility feature.
Select
- Structure
- Add DROP TABLE
- Add IF NO EXISTS
- Add AUTO_INCREMENT VALUE
- Enclose table and field names with backquotes.
Select
- Data
- Complete inserts
- Extended inserts
- Use hexadecimal for binary fields.
Select Save as file
In File name template: _SERVER_name your db here. (Here you can use any name you want)
In Compression specify your choice.
Click Go.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น