Backup Software / Features / MySQL Workbench Backup
MySQL Workbench is a powerful, popular utility capable to administer, modify and backup MySQL databases. A healthy choice of features makes MySQL Workbench just as preferred by some admins and developers as for phpMyAdmin or HeidiSQL for others.
MySQL Workbench is very good for general purposes related to MySQL managing, although some specialized operations, like backing up databases on MySQL, are still better performed by specialized software like Handy Backup.
Version 7.9.7, built on 23 November, 2017 65.7 MB
MySQL Workbench provides a set of functions and features related to manual MySQL administering and data managing. These features include schema control tools, visual model and object managing tools, database migration features and many other instruments expanding the basic toolkit.
MySQL Workbench backup and restore instrument is a GUI built beyond the MySQL Enterprise Backup tool. It allows flexible task setup with encrypting, incrementing, fine-tuning datasets, making MySQL Workbench scheduled backup and manipulating with many other aspects of data saving.
An administrator can force MySQL Workbench backup for a schema, a table or a DB (with some possible extra or excluded options tuned for a task) via the graphic interface, as a part of a daily administering activity linked to MySQL databases.
To back up MySQL databases, both products mentioned are almost equally good (perhaps, equally best). Therefore, for saving only MySQL data, you can use MySQL Workbench backup database tool or Handy Backup software. However, some differences between the products still exist:
Handy Backup keeps data copies preserving an original data format, unless other declared by a user. Therefore, “backups” created by Handy Backup are perfect copies of data ready to use just by a place where backups are kept, requiring no necessary restoration before using.
MySQL Workbench backup database feature provides only a full and an incremental backup technique, and Handy Backup completes this set by the more capable and advantageous (for databases) differential backup, mixed backup, as well as with automated versioning and time stamping.
Typically, MySQL data are not a single type of information used on some server. Much more frequently, these data are a part of more complicated structure, such as a dynamic part of a website content. Handy Backup can back up all these data, and MySQL Workbench cannot.
These advantages of a dedicated MySQL backup software over the built-in MySQL Workbench backup can play a crucial role in a particular backup strategy developed just for some server or data center. Or else, the role of these features can be much smaller than MySQL Workbench is for you.
Choosing “MySQL” data source on the step 2 with Handy Backup.
Version 7.9.7, built on 23 November, 2017. 65.7 MBBackup Software from Novosoft LLC. 249 USD per license.
Handy Backup Small Server will help you easily back up and restore your MySQL databases. Try free for 30 days!
For a convenience, let us briefly compare the capabilities of MySQL Workbench with other popular tool for managing MySQL databases: phpMyAdmin and HeidiSQL. For each tool, we have to define some pros and cons demonstrated and mentioned by many users throughout the world.
A classic, solid and undemanding utility, phpMyAdmin has a lot of fans among MySQL users.
More advanced and featured than phpMyAdmin, HeidiSQL software has some extra capabilities such as more powerful UI, data synchronization options and great user management system.
Almost a perfect tool, MySQL Workbench has all required capabilities for managing MySQL databases including an automation for some frequent activities. Moreover, it is expanding and changing constantly, meeting the requirements of newer and newer MySQL-related technologies.
Therefore, we are recommending using MySQL Workbench for any MySQL daily administering tasks, and setting up a copy of Handy Backup along with it to perform backing up, cloning and replicating MySQL databases and tables in a fully automated mode, instead of using MySQL Workbench backup.
Loading comments, please wait...
Copyright © 2004-2017 Novosoft LLC. All rights reserved. Handy Backup software.
United States, P.O.Box 535, Louisville, OH 44641 Tel.: +1 (707) 703-13-11
Back to Top