Online Documentation for SQL Management Studio for MySQL

Using Desktop Panel


Desktop Panel is the main working area of SQL Management Studio for MySQL. The content of the Desktop Panel scratch changes dynamically according to the current selection in the Navigation bar of the main toolbar.

 

Getting Started - Desktop Panel

 

Using the Desktop Panel items you can:

 

DBManagement launch the all-in Database management program (SQL Manager for MySQL) and run basic MySQL services:

  • Backup Tables (with or without a template);
  • Restore Tables (with or without a template);
  • Analyze Tables (with or without a template);
  • Check Tables (with or without a template);
  • Repair Tables (with or without a template);
  • Optimize Tables (with or without a template);
  • Truncate Tables (with or without a template);
  • Dump Database (with or without a template);
  • Restore Database Dump (with or without template);

 

DataManipulation launch integrated Data manipulation utilities:

  • Data Export for MySQL (with or without a template, GUI or console version);
  • Data Import for MySQL (with or without a template, GUI or console version);
  • Data Pump for MySQL (with or without a template, GUI or console version);
  • Data Generator for MySQL (with or without a template, GUI or console version);
  • SQL Script for MySQL (with or without a template, GUI or console version);

 

DataAnalysis launch utilities implemented for Data analysis:

  • Data Comparer for MySQL (with or without a template, GUI or console version);
  • DB Comparer for MySQL (with or without a project file, GUI or console version);
  • DB Extract for MySQL (with or without a template, GUI or console version);
  • SQL Query for MySQL;

 

TemplateManagement manage templates for each of the integrated tools and services;

 

CustomTasks manage miscellaneous tasks;

 

TaskScheduler manage scheduled tasks;

 

Logs manage task logs;

 

InternetResources use available Internet resources:

  • visit SQL Studio Home Page;
  • browse SQL Studio pages dedicated to Frequently Asked Questions;
  • browse online documentation concerning SQL Studio components;
  • visit MySQL related resources;

 

StudioDirect use the SQL Studio Direct feature;

 

Support get technical support online.

 

Hint: To activate/deactivate brief descriptions displayed for each tool on the Desktop Panel, you can use the View | Show Tool Descriptions item of the main menu.