Backup a any type of Database in important in feature in case anything happen wrong.

We can Backup and Store MySQL Database in multiple Method to avoid losing database.

METHOD 1: [ Using Phpmyadmin ]

If you are using MySQL in Wamp,Xampp or any other server you can manage database in phpmyadmin with GUI support. Follow the steps for backup and restore MySQL Database

EXPORT:

1. Open Phpmyadmin [ localhost/phpmyadmin ]

2. Then Click Export button

3. For Quick Export directly you can click ok

4. You can choose custom option for advanced export [ For example export selected database only ]

5. You can also export database in different format

   Export Formats:

• CodeGen
• CSV
• CSV for MS Excel
• Microsoft Word 2000
• JSON
• LaTeX
• MediaWiki Table
• OpenDocument Spreadsheet
• OpenDocument Text
• PDF
• PHP array
• SQL
• Texy! text
• YAML

6. After selecting the Export database format, then click OK

7. The database backup will be download automatically

IMPORT:

1. Open Phpmyadmin [ localhost/phpmyadmin ]

2. Click Import Button

3. Then choose the backup file  using 'Choose File' button

4. Then Select the Format of the file

5. You can Import Database in following formats

• CSV
• MediaWiki Table
• OpenDocument Spreadsheet
• ESRI Shape File
• SQL
• XML