Create MySQL database backup in PhpMyAdmin xampp

Export your complete MySQL database into .sql file,XML,CSV,MS Excel,JSon,Latex,MediaWiki table,pdf,php array,text,Yaml format.

Creating backup means copying your whole MySQL database into single file format and save some other place so if you loose your database for some kind of reason then you must be able to recover your whole database+tables. Creating database backup process are also called as Exporting complete MySQL database backup. So here is the complete step by step tutorial for Create MySQL database backup in PhpMyAdmin xampp.

How to Create MySQL database backup in PhpMyAdmin xampp.

1. Start your xampp control panel.

xampp control panel v322

2. Select your database which backup you want to create.

testdb

3. Click on Export button.

export

4. Now Select Format as ” SQL ” and click on Go button.

Create MySQL database backup in PhpMyAdmin xampp

Here you go now your database backup file will be download automatically into your system.

List of Available exporting file format:

  • CodeGen.
  • CSV.
  • CSV for MS Excel.
  • Microsoft word 2000.
  • JSON.
  • LaTeX.
  • MediaWiki Table.
  • Open Document Spread sheet.
  • Open Document text.
  • PDF.
  • SQL.
  • Text! Text.
  • XML.
  • YAML.