EMS DB Extract for MySQL

EMS DB Extract for MySQL is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data.

Features: MS DB Extract for MySQL is a easy-to-use tool for creating MySQL database backups. But these backups are created with SQL scripts. The utility would let you save all the metadata of all the database objects as well as table data. The extraction process is quite flexible and lets you selects specific objects and data tables to be extracted. Tweaking of the extraction process also is possible. The graphical wizard included will take you through the process step by step. For the experts there is a command line feature that lets you create backups in a single touch.

You can set up constraints for the extracted data if you like. You can also insert statements to clean up the tables before inserting the extracted data. Depending on the dependencies of the data to be extracted, the data can be extracted in the same order. The resultant script of the extraction scenario can be compressed and split into volumes. You select any charset for the data going into the result file. Since the utility supports Unicode, you can handle multi-language data quite easily. All the extraction parameters that you set for a particular session can be saved for future use. Extraction of metadata and data via the command line is possible by specifying a configuration file. It is possible to access database via the SSH tunnel.

Overall: Quite a good utility that`ll let you back up MySQL data.

EMS DB Extract for MySQL is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract process you can select objects and data tables for extract and tune many other extract options. MySQL Extract includes a graphical wizard, guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.
Key Features:
Support of Unicode data
User-friendly wizard interface
Selecting database objects for extraction
Possibility to define constraints for extracted table data
Possibility to insert statements for emptying tables before inserting extracted data
Extracting table data to SQL script as INSERT statements
Possibility to extract database objects in the correct order according to their dependencies
Possibility to compress the result script and split it into volumes
Possibility to select charset for the result file
Saving all extraction parameters set on the current wizard session
Command-line utility to extract metadata and data using the configuration file
Access to database through SSH tunnel