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.
2. Select your database which backup you want to create.
3. Click on Export button.
4. Now Select Format as ” SQL ” and click on Go button.
Here you go now your database backup file will be download automatically into your system.
List of Available exporting file format: