Online Documentation for SQL Management Studio for MySQL
Using services
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.
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 local host to files for future restore.
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 the unused space in tables and defragments the data files.
Truncate Tables
Empties tables completely by dropping and recreating them.
Dump Database
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.
See also: |