- Published on
How to backup MySQL in diferent formats
- Authors
- Name
- Nico Bistolfi
- @nicobistolfi
The best way to have mysql backed up in different formats is to use PhpMyAdmin, you need to go to a database and the tab Export.
You can setup a Quick backup in different formats such as:
- CodeGen
- CSV
- CSV for Excel
- Microsoft Word 2000
- JSON
- Latex
- MediaWiki Table
- Open Document Spreadsheet
- Open Document Text
- PHP Array
- SQL
- Texty! text
- XML
- YAML
The best way to backup and be sure you can restore it fully functional is to use SQL backup, also you can backup your store procedures, trigger, useras and any other particular configuration of the database.
Screenshot for PhpMyAdmin: