MySql has two awesome tools which make life a lot more easier for people who don’t like to work with command prompts . MySql Query Browser and MySql Admininstrator are bundled together and available for download at http://dev.mysql.com/downloads/gui-tools/5.0.html .You can use the Query Browser to execute all DML operations and the Adminstrator for all DDL operations. The Adminstrator tool can do a complete backup of the database really fast depending on the size of your database. It creates a single file with the sql staments to create the db , table and constraints and also insert statements to populate them . This is really useful when debugging production issues . Data from the production environment can be easily exported to the dev environment . There is no support for masking private data which is a major drawback for this backup tool .
