This blog talks about MySQL Enterprise Backup integration with Workbench and how the Workbench UI can be used to configure and operate MEB.
The MySQL Utilities Team is pleased to announce the latest GA
MySQL Utilities. This release marks a milestone of concentrated effort to
expand the use of utilities in more diverse installations through improved
robustness, error handling, and quality.
There are number such enhancements in this release. In this post we will
highlight a few of the more significant improvements.
- (new utility) MySQL .frm Reader (mysqlfrm) - read .frm files and generate CREATE statements with or without a server connection.
- (revised) improved documentation including a section on example administrative tasks - see http://dev.mysql.com/doc/workbench/en/mysql-utilities.html
- MySQL Utilities is packaged for .msi, .rpl, .deb platforms and source .tar/.zip …
New GUI, 30+ New Features, and Major New Components
Oracle is excited to announce the immediate availability of the production-read, GA release of MySQL Workbench 6.0, available for download under the GPL, as well as part of the Commercial MySQL Standard, Enterprise, and Cluster Carrier Grade Editions with 24x7 global support.
The need by database professionals for management tools has increased with expanding data volumes, web, cloud and mobile computing growth. Improvement and additions in MySQL Workbench helps developers and administrators better manage these dynamic data environments. This latest GA release includes many new features and a modernized user interface that allows users to simplify MySQL database development, design and administration.
The goal of MySQL Workbench 6.0 is to simplify and improve the workflow in the graphical user interface (GUI) as well as adding new features and …
The MySQL Developer Tools team is pleased to announce the availability of the first beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 100 bug fixes, 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use. Please test and file your bug reports at http://bugs.mysql.com
As always, MySQL Workbench is natively available on Windows, Mac, Linux.
Improvements in MySQL Workbench 6.0:
- a new redesigned Home screen
- the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
- improved model Synchronization, lets you compare and update your …
In case you missed it, MySQL Utilities 1.3.0 (alpha) was released last week. MySQL Utilities is a component of MySQL Workbench, but it’s been broken out into a separate download allowing command-line users access unencumbered by a pretty GUI interface. Plus, it has some new features – most importantly to me, a utility (mysqlfrm) which can read .FRM files and produce CREATE TABLE statements as a result. This will be very useful for recovery processes, in conjunction with InnoDB transportable tablespaces in situations where the InnoDB system tablespace is corrupted, and you don’t know the exact table definition.
Have you ever wondered what was in those .frm files littered
throughout your data directory? Better still, have you
encountered a situation where your data is either missing (was
deleted) or damaged and all you have is the .frm files but don't
know the structure of the table? Well, wonder no more!
The MySQL Utilities Team is pleased to announce the newest utility - the .frm reader (mysqlfrm). This utility is designed to read .frm files and produce a facsimile of the CREATE statement for the table or view.
That's Impossible! How Can That Work?
It works by making a copy of the .frm file(s) and launching a new, read-only instance of your existing server. The server need not be running but you are required to provide an open port for the new instance with the --port option.
The utility will launch the cloned server without reading your configuration file (--no-defaults). The utility also makes some …
The MySQL Utilities Team is pleased to announce a major
advancement of MySQL Utilities. It is now available as a separate
That's right. If you want to use MySQL Utilities without installing MySQL Workbench, you can do that now.
The Utilities release-1.3.0 has been built for Windows Installer, RPM archive, and .tar/.zip. We have also made downloads for source only if you want to use Utilities to develop your own utilities or install the product in custom location. We plan to add other repositories in the future.
Is that it? Well, not quite. We have also included a new utility - the .frm Reader. See the blog, "New Utility: .frm Reader" for more information.
If you'd like to try out the new download, visit the MySQL Workbench download page:
The MySQL Utilities Team is pleased to announce our latest
release, version 1.2.1. This release contains many quality
improvements and enhancements to the HA and Replication
utilities. The following lists some of the most significant
- Improved transaction gathering algorithm for failover
- Skips slaves that are already caught up
- Ensures all transactions in the relay logs on the slaves are executed first
- External scripts in mysqlfailover and mysqlrpladmin now receive the old and new master information
- Improved demote master handling for switchover
- Improved connection error handling
- Quoting of tables and database names has been improved
- Login-path feature now reads port and socket
The utilities team continues to focus on improving usability, making features easier to use, and …[Read more]
The MySQL developer tools team announces the availability of version 5.2.46 of the MySQL Workbench GUI tool. This version contains 30 resolved bugs and support for the new MySQL 5.6 server.
Additionally, MySQL Utilities 1.2.0 have been included on the distribution.
For a full list of issues fixed in this release, see the release notes.
Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products.
Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
Workbench Documentation can be found …[Read more]
I recently had a need to import a bunch of data into MySQL, and for reasons I won’t get into here, LOAD DATA INFILE wasn’t working for me. I was in a hurry to get the data into MySQL so that I could filter it, and didn’t have time to work through my LOAD DATA INFILE issues. Looking around for another way to quickly get my tab-delimited data into MySQL quickly, I decided to use the MySQL for Excel plugin. If you haven’t seen this yet, and you have Excel, it might be worth your while.
In my case, I was able to quickly copy and paste the tab-delimited text file into an Excel spreadsheet, connect MySQL for Excel to the MySQL database and append the data to the existing table. You’ll need to have Excel, MySQL and the MySQL for Excel plugin. The latter two can be installed from a single download using the …[Read more]