MySQL Administration Tool for Efficient Work!

dbForge Studio for MySQL provides you with a feature-rich MySQL Admin Tool Set to administer and manage MySQL server databases in a secure and easy way. It is designed for both developers and database administrators. A user-friendly graphical interface allows you to perform SQL queries and scripts, manage privileges, export and back up data, manipulate user accounts, manage MySQL services, etc.

Backup and Restore

Create backups and manage backup scripts with the Database Backup wizard. It will help to keep your data safe.
Learn more about how to back up a MySQL database at the MySQL backup tool page.

Database Backup Wizard

User Administration

Administering user accounts and privileges is a routine and important task. Security Manager helps you add and remove user accounts, change their properties, and assign privileges in no time.

Security Manager

MySQL Session Manager

Session Manager shows all current processes in the database. Same as the MySQL show processlist command, it gives a table view of each process parameter including id, user, host, database, command, time, state, or info.

It is useful for detecting bad queries that consume lots of server power and make other queries run slowly or cripple new connections. Select a query id from Session Manager to terminate it using the KILL command.

Session Manager Dialog Box

Server Configuration

The Server Variables window allows you to adjust server configurations in accordance to your needs.

Server Variables

Service Control

Administer several MySQL servers on different computers with our Service Control window. It displays added services of local and remote computers. Use the Service Control window to manage MySQL services:

  • Start, stop and restart services
  • Add a new service
  • Associate connections with a service
Service Control

Server Connections

The Database Explorer window displays all server connections. It is quite easy to:

  • Change connection properties
  • Add and remove connections
  • Navigate through the connections tree
Database Explorer Window

Table Maintenance

The tool allows you to perform the following tasks:

  • Analyze tables
  • Check tables for errors
  • Optimize data files
  • Repaire corrupted tables
Table Maintenance Dialog Box

Data Export and Import

You can choose a data format while exporting or importing data. Specify other additional data export and import options with corresponding tools wizards.

More about Data Export and Import Tools »

Data Export and Import

Find Database Data and Objects Feature

Use the Search window to search through the database and find both, required objects and data. Facilitate a search process by specifying additional search criteria.

Search window

Copy Database

The Copy Database functionality allows you to transfer databases between servers in a few clicks. Just specify the source and target connections, select the desired database, set additional options if it's needed and watch the migration process being carried out.

Copy Databases settings

Availability

Features

Pro

Stand

Exp

Backup and restore
Yes
Yes
Click to view restrictions
User administration
Yes
Yes
Yes
Server configuration
Yes
Yes
Yes
Service control
Yes
Yes
Yes
Server connections
Yes
Yes
Yes
Table maintenance
Yes
Yes
Yes
Data export and import
Yes
Yes
Click to view restrictions
Find object feature
Yes
Yes
No

* Express Edition does not support command line, backup projects, auto deletion of old backup files, compression, backup files larger than 1MB.

** CSV format in the Express Edition has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported also.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.