MySQL IDE by Devart 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.
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.
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.
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.
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:
You can choose a data format while exporting or importing data. Specify other additional data export and import options with corresponding tools wizards.
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.
* 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.
