Online Documentation for SQL Management Studio for MySQL
SQL Studio integrated features provide easy way to run all native MySQL services which are intended for database maintenance. The following services and server tools are available:
To run a service, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard with this template.
Saves tables from local host to files for future restore.
Restores tables from files on disk to the database.
Analyzes and stores the key distribution for tables.
Checks database tables for consistency and identifies the corruption of tables.
Repairs database tables that are corrupted.
Reclaims the unused space in tables and defragments the data files.
Empties tables completely by dropping and recreating them.
Dump a MySQL database or a collection of databases into SQL Script using 'mysqldump' utility.
Restore Database Dump
Restore database or a collection of databases from SQL Script.