Online Documentation for SQL Management Studio for MySQL

Using services


SQL Studio's integrated features provide an easy way to run all native MySQL services that are intended for database maintenance. The following services and server tools are available:

 

 

Database Management - Services

 

 

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.

 

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

 

 

Backup Tables

Saves tables from the local host to files for future restoration.

 

Restore Tables

Restores tables from files on disk to the database.

 

Analyze Tables

Analyzes and stores the key distribution for tables.

 

Check Tables

Checks database tables for consistency and identifies the corruption of tables.

 

Repair Tables

Repairs database tables that are corrupted.

 

Optimize Tables

Reclaims unused space in tables and defragments the data files.

 

Truncate Tables

Empties tables completely by dropping and recreating them.

 

Dump Database

Dumps a MySQL database or a collection of databases into a SQL Script using the 'mysqldump' utility.

 

Restore Database Dump

Restores a database or a collection of databases from SQL Script.