Live Chat Software by NetForChoice
Knowledgebase: Mysql
How to backup your Mysql database with phpMyAdmin
Posted by on 08 July 2016 05:01 PM

 

1.Open phpMyAdmin.


2.Click Export in the Menu to get to where you can backup you MySql database.

 

 

 

 

 

3. Make sure that you have selected to export your entire database, and not just one table.

There should be as many tables in the export list as showing under the database name. 

4. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value.

Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field".

Export type set to "INSERT".
5. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Support from NetForChoice