13 09_51

How to backup MySQL in diferent formats

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
  • PDF
  • 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:

13 09_51

Published by

Nicolás Bistolfi

CTO & Co-founder at woOw | Co-founder at Touchit! AIESECer, Oil Painter and kind of a Guitar Player. Made in Uruguay

Leave a Reply

Your email address will not be published. Required fields are marked *