How to take Database Backup using phpMyAdmin?

How to take Database Backup using phpMyAdmin?

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

First you need phpMyAdmin which is a MySQL Database Administration Tool.

1 – Open phpMyAdmin

2 – Click on Export

3 – Under Export – Select the database you want to backup

4 – Select SQL

5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add AUTO_INCREMENT VALUE and Enclose table and field names with backquotes.

6 – Select Data, Complete inserts, Extended inserts and Use hexadecimal for binary fields.

7 – Select Save as file your data base. Here you can use any name you want.

9 – In Compression specify your choice.
10 – Click Go.
  • 0 Users Found This Useful
Was this answer helpful?