Planet MySQL

MySQL Utilities meets the world’s ugliest table

+4

-0

posted by Todd Farmer of team blog MySQL Support Team on Wed 10 Apr 2013 00:14 UTC
Tags:

(edit) mysql, data recovery, Workbench, MySQL Utilities

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

+7

-0

posted by Chuck Bell on Fri 05 Apr 2013 22:10 UTC
Tags:

(edit) mysql, database, Workbench, administration, Utilities

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

[Read more...]

Introducing MySQL Utilities release-1.3.0

+5

-0

posted by Chuck Bell on Fri 05 Apr 2013 21:59 UTC
Tags:

(edit) mysql, database, Workbench, administration, Utilities

The MySQL Utilities Team is pleased to announce a major advancement of MySQL Utilities. It is now available as a separate download!

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:

[Read more...]

Introducing MySQL Utilities release-1.2.1

+4

-0

posted by Chuck Bell on Fri 05 Apr 2013 21:53 UTC
Tags:

(edit) mysql, database, Workbench, administration, compare, Utilities, gtid

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 improvements.

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,
[Read more...]

MySQL Workbench 5.2.46 GA released

+2

-0

posted by Michael Zinner on Tue 05 Feb 2013 13:37 UTC
Tags:

(edit) mysql, Announcements, Workbench

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.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found

[Read more...]

Using MySQL for Excel

+4

-0

posted by Todd Farmer of team blog MySQL Support Team on Fri 09 Nov 2012 03:45 UTC
Tags:

(edit) mysql, Workbench, mysql on windows, MySQL Installer

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

[Read more...]

New in MySQL Utilities release-1.1.0

+0

-0

posted by Chuck Bell on Sun 30 Sep 2012 01:11 UTC
Tags:

(edit) mysql, database, Workbench, Utilities

New in MySQL Workbench 5.2.44 is the latest release of MySQL Utilities 1.1.0. This release contains a new utility called the MySQL Utilities Users' Console (mysqluc).

The MySQL Utilities Users' Console is designed to make using the utilities easier. While it is not a new utility in the sense it doesn't provide any new functionlity for managing MySQL servers or data, it does provide a unique shell environment with command completion, help for each utility, user defined variables, and type completion for options.

That's right, you no longer have to type out the entire name of the utility. For example, you can type mysqldbe and press the TAB key and it will complete the command as mysqldbexport. Don't remember the name of a database utility you want to use? That's no problem either - just type mysqldb and press TAB twice. The console will list all of

[Read more...]

MySQL Utilities Frequently Asked Questions

+3

-0

posted by Chuck Bell on Wed 09 May 2012 20:01 UTC
Tags:

(edit) mysql, database, Workbench, administration, Utilities

Momentum for MySQL Utilities continues to build. I hosted a webinar recently about MySQL Utilities (available on-demand from the link below), which generated a lot of interest and some good questions.

http://event.on24.com/eventRegistration/EventLobbyServlet?target=lobby.jsp&eventid=448952&sessionid=1&key=7E741ED049DFBF49D10C90A2B62E410F&eventuserid=63530507

With so many questions and ideas coming in I decided to create a blog of FAQs. I plan to add these to the MySQL documentation as well. Keep your ideas and questions coming!

I hope you find these questions enlightening. I have grouped them for easier reading. You can find the MySQL Utilities

+2

-0

posted by Chuck Bell on Wed 09 May 2012 19:45 UTC
Tags:

(edit) mysql, database, synchronization, Workbench, administration, compare

The mysqldiff and mysqldbcompare utilities were designed to produce a difference report for objects and in the case of mysqldbcompare the data. Thus, you can compare two databases and produce a report of the differences in both object definitions and data rows.

While that may be very useful, would it not be much more useful to have the ability to produce SQL commands to transform databases? Wait no longer! The latest release of MySQL Utilities has added the ability to generate SQL transformation statements by both the mysqldiff and mysqldbcompare utilities.

To generate SQL transformations in either utility, simply use the --sql option to tell the utility to produce the statements.

Object Transformations with mysqldiff

If you would like to compare the schema of two databases (the objects and their

[Read more...]

MySQL Utilities and Global Transaction Identifiers

+7

-0

posted by Chuck Bell on Tue 10 Apr 2012 15:40 UTC
Tags:

(edit) mysql, Replication, Python, Workbench, gtid

The new MySQL 5.6 Development Milestone Release (DMR) includes many new enhancements. One of the most impressive is the use of Global Transaction Identifiers (GTIDs) for replication. With GTIDs enabled, administrators no longer need to keep track of binary log files and positions. In a nutshell, GTIDs simplify the setup and maintenance of replication.

MySQL Utilities has taken this a step further by providing two new utilities that automate two of the most complex replication administration tasks - switchover and failover. Switchover is changing the role of an active, healthy master to one of its slaves whereas failover is the act of promoting a candidate slave to become the new master. Clearly, switchover is an elective operation and failover is performed when there are issues with the master.

The GTID utilities are included in release-1.0.5 of

[Read more...]

MySQL Workbench 5.2.39 GA Released

+1

-0

posted by Michael Zinner on Tue 10 Apr 2012 15:36 UTC
Tags:

(edit) mysql, Announcements, Workbench

The MySQL Developer Tools team is announcing the next maintenance release of its flagship product, MySQL Workbench, version 5.2.39. This version contains MySQL Utilities 1.0.5, a set of command line Python utilities for helping to perform and script various administration tasks for MySQL. A complete list of changes in this release of the Utilities can be found at:
http://dev.mysql.com/doc/workbench/en/wb-utils-news-1-0-5.html

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

+11

-0

posted by Luca Olivari on Thu 29 Dec 2011 12:31 UTC
Tags:

(edit) mysql, Oracle, Windows, Business, Databases, enterprise, Events, community, conference, marketing, opensource, cluster, Workbench, 2011

I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:

[Read more...]

MySQL Workbench 5.2.37 GA Released

+0

-0

posted by Michael Zinner on Mon 26 Dec 2011 21:55 UTC
Tags:

(edit) mysql, Announcements, Workbench

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/), version 5.2.37.

This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor.

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

[Read more...]

MySQL Workbench 5.2.37 GA Released

+0

-0

posted by Michael Zinner on Mon 26 Dec 2011 21:55 UTC
Tags:

(edit) mysql, Announcements, Workbench

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/), version 5.2.37.

This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor.

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

[Read more...]

Workbench Scripts

+0

-0

posted by Keith Larson on Fri 23 Sep 2011 21:45 UTC
Tags:

(edit) mysql, Workbench

A was checking out the new Workbench today after I saw this blog post http://wb.mysql.com/?p=1169

It all worked great and very easy. Nice clean code that helps out the PHP Developer.
example:
$host="localhost";
$port=3306;
$socket="";
$user="";
$password="";
$dbname="";

$con = new mysqli($host, $user, $password, $dbname, $port, $socket)
    or die ('Could not connect to the database server' . mysqli_connect_error());

//$con->close();

$query = "SELECT * FROM exampledb";

if ($stmt = $con->prepare($query)) {
    $stmt->execute();
    $stmt->bind_result($field1, $field2);
    while ($stmt->fetch()) {


[Read more...]

Show your support for MySQL Workbench !

+1

-1

posted by Keith Larson on Wed 17 Aug 2011 18:33 UTC
Tags:

(edit) mysql, Workbench

The 2011 DevProConnections CommunityChoice Awards has two categories that include nominations for MySQL Workbench !
You can support MySQL Workbench with your vote. The two categories that include Workbench are, “Component Set” (page 1 # 7) and “IDE” (page 2 #14).
The survey is available here and information about workbench is always available here: http://www.mysql.com/products/workbench/ (http://www.mysql.com/products/workbench/)

Tech Writer Wanted for MySQL Workbench & Connectors

+1

-0

posted by Stefan Hinz on Wed 25 May 2011 01:12 UTC
Tags:

(edit) mysql, sun, connectors, job, Workbench, docs

The MySQL Documentation Team is looking for a senior technical writer. Main areas to cover are MySQL Workbench and MySQL Connectors. The position is for EMEA.

Candidates should be prepared to work intensively with our developers and support organization when writing documentation. Being a distributed team, we meet mostly on IRC and coordinate our work through email and versioning systems such as Subversion. The base format we're using is DocBook XML, and we're not just writing but also processing and publishing all our documentation ourselves.

This means you

+0

-0

posted by Stefan Hinz on Wed 25 May 2011 01:12 UTC
Tags:

(edit) mysql, sun, connectors, job, Workbench, docs

The MySQL Documentation Team is looking for a senior technical writer. Main areas to cover are MySQL Workbench and MySQL Connectors. The position is for EMEA.

Candidates should be prepared to work intensively with our developers and support organization when writing documentation. Being a distributed team, we meet mostly on IRC and coordinate our work through email and versioning systems such as Subversion. The base format we're using is DocBook XML, and we're not just writing but also processing and publishing all our documentation ourselves.

This means you

[Read more...]

MySQL Workbench Utilities

+2

-0

posted by Lars Thalmann on Wed 13 Apr 2011 08:00 UTC
Tags:

(edit) mysql, Workbench, administration, Utilities

One of the many new things that is being introduced this week are some great new external tools for managing MySQL servers. These are available in MySQL Workbench under the name MySQL Workbench Utilities.

It is a package of easy-to-use utilities for maintenance and administration of MySQL servers. These utilities encapsulate a set of primitive commands bundling them so that you can perform macro operations with a single command.

Some of the key features of MySQL Workbench Utilities are:

Plugin for MySQL Workbench 5.2.31
Available under the GPLv2 license
Written in Python
Easily to extend using the supplied library

How Does It Work?
There are two ways to access the utilities from within the MySQL Workbench.

You can click on the drop down arrow

[Read more...]

MySQL Workbench Utilities

+0

-0

posted by Chuck Bell on Thu 07 Apr 2011 20:05 UTC
Tags:

(edit) Workbench, administration, mysq, Utilities

Introducing MySQL Workbench Utilities
One of the many new things that is being introduced during the Collaborate 2011 and 2011 MySQL Users’ Conference are some great new additions to some of the external tools for managing MySQL servers. One of those tools receiving updates is the MySQL Workbench.

One of the jewels in a long list of new features is the addition of new command-line utilities to help you administer your servers. The new feature is called MySQL Workbench Utilities. It is a package of easy-to-use utilities for maintenance and administration of MySQL servers. These utilities incapsulate a set of primitive commands bundling them so that you can perform macro operations with a single command. Some of the key features in MySQL Workbench Utilities include:

Plugin for MySQL Workbench 5.2.31
Available under the GPLv2

[Read more...]

MySQL Workbench on CentOS

+0

-0

posted by Daniel van Eeden on Thu 03 Mar 2011 13:46 UTC
Tags:

(edit) centos, Workbench, myql

Every once in a while I use MySQL Workbench. First is was only for Windows, then it was unstable and now it is very well usable. Or at least that is the situation when you run on a recent Ubuntu machine.

I'm now using CenOS 5.5 in a VirualBox VM to do some testing. Unfortunately the download site for MySQL Workbench has RPMs for RedHat 6 and Fedora Core 14 and some other platforms. No CentOS, No RHEL5, only the latest Fedora en RHEL.

So I downloaded the RHEL6 RPMs and tried to install them with yum localinstall, but that failed. So they are not backwards compatible with 5.5.

Turns out that CentOS/RHEL 5 doesn't have the required libraries to support MySQL Workbench.

And unfortunately CentOS 5.5 is still the latest release. So an upgrade to CenOS 6 is not yet possible.

Webinar: Designing MySQL Databases (Italian) - Nov, 25@10am CET

+4

-0

posted by Luca Olivari on Tue 23 Nov 2010 07:24 UTC
Tags:

(edit) mysql, webinars, Workbench

We already have more that 500 registrants for this MySQL web seminar (http://mysql.it/news-and-events/web-seminars/display-587.html). Join us and the crowd to learn the design dos and don'ts for MySQL. We will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios.

In this technical presentation, we will cover:

MySQL design basics

Data Modeling Basics

Physical and Logical Models
"Dos" and "Don'ts"

How to design MySQL for your specific application

[Read more...]

How MySQL Workbench breaks itself

+6

-0

posted by Giuseppe Maxia on Sun 21 Nov 2010 16:32 UTC
Tags:

(edit) mysql, bugs, Testing, Workbench

Once upon a time, there was a policy in MySQL not to add new features after the beta stage.
To my surprise, MySQL Workbench 5.2.30 introduces a new feature, the query formatter. I gave it a try. The results are not extremely encouraging. Granted, it's a plugin and not a feature in the core application, but nonetheless one would expect something more stable in a GA release, especially since the plugin features are displayed in the main menu, and unless you have read the announcement, you couldn't easily tell the core from the plugins.
This is what I have got in just a few minutes:

Bug #58356: beautify function fails on CREATE TABLE
Bug #58357: beutify function erases statement on CREATE

[Read more...]

Workbench called me a dummy!

+5

-0

posted by Todd Farmer on Thu 02 Sep 2010 05:16 UTC
Tags:

(edit) mysql, Tools, Workbench

Seriously, it did. Sorta.

I use Workbench for my daily work, and it’s a great tool. If you haven’t tried the 5.2 release yet, you should. While performing some maintenance, I happened to issue a DELETE statement against a table which had no indexes (it was 10 rows), and Workbench complained:

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

It turns out this is a new feature in 5.2.26 (and is still there in 5.2.27) – Workbench now uses the equivalent of –safe-updates mode for the mysql command-line client (also known as the

+5

-0

posted by Giuseppe Maxia on Fri 14 May 2010 16:40 UTC
Tags:

(edit) mysql, DBA, Workbench, command line

As everyone knows, I am a command line guy. I am very much comfortable with the shell prompt and the command line SQL client. I do most of my work that way, and I am very much productive.
However, there comes a time when even for a command line enthusiast a GUI can be helpful.
Here comes the latest MySQL Workbench 5.2.
There are two areas where I feel that WB can give me a hand:
The first is when looking at tables that contain BLOB columns. Sure I can deal with them at the command line, but this editor makes my life easier.

When a column contains a BLOB, you can open the

[Read more...]

North Texas 1st meeting of the year -- Workbench & Cookies

+2

-0

posted by Dave Stokes on Sat 02 Jan 2010 16:45 UTC
Tags:

(edit) meeting, Workbench

Happy New Year! Monday night is the first meeting of the North Texas MySQL Users Group for 2010! And the topic for discussion will be MySQL Workbench (http://mysql.com/products/workbench/).

Workbench is a tool for visual database design, schema documentation, change management, and is replacing the old MySQL GUI tools. If you have not tried the latest releases, you will be for a pleasant surprise.

NorthTexasMySQL.org meets at 7:00PM sharp at the Sun Offices, Suite 700, 16000 Dallas Tollway, Dallas TX. We welcome all who want to know more about MySQL, databases, or Open Source. Admission is free and I will bring cookies!

New Features in MySQL Workbench 5.2

+1

-0

posted by Mike Frank on Thu 10 Dec 2009 23:02 UTC
Tags:

(edit) mysql, Uncategorized, Workbench, query browser adminstrator, sql editor

For those of you that attended today’s webinar or for those of you who were unable to do so, we discussed and demo’ed many of the new exciting features in Workbench 5.2.

The presentation slides in pdf and audio are available -

http://www.mysql.com/news-and-events/on-demand-webinars/display-od-472.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-472.html)

If you are currently using MySQL Query Browser or MySQL Administrator, you’ll be pleased to know that their functionality is now in MySQL Workbench, creating a single, unified GUI for designing, developing and administering MySQL databases.

For more info visit:

WB Downloads: http://dev.mysql.com/downloads/workbench/
WB Forums:

[Read more...]

MySQL schema maintenance

+3

-0

posted by Giuseppe Maxia on Thu 03 Dec 2009 23:57 UTC
Tags:

(edit) mysql, maintenance, synchronization, Workbench, schema

At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.
The slides are available at slideshare.

Interesting questions: ([updated] with answers from the development team

[Q] Are there plans to administer MySQL Cluster with Workbench?
[A] Not that we know of.

[Q] Can Workbench deal with user permission maintenance across servers? (especially in cases where development and production users

+3

-0

posted by Giuseppe Maxia on Sun 29 Nov 2009 18:30 UTC
Tags:

(edit) mysql, speaking, conference, Development, DBA, Workbench, Competition, gearman, codebits, lisbon

Codebits is approaching. Form December 3rd to 5th, this gathering of 600 developers for a conference, which is also and foremost a competition, will occupy the mind of the best coders in Europe.
I will be a speaker, with two sessions:

Schema maintenance in MySQL, focusing mainly on MySQL Workbench, but with an introduction to the other choices.
Introduction to Gearman - a distributed, language and OS independent system for dynamic programming.

Also Lenz will be there, and quite busy. He will also have two sessions:

[Read more...]

SSH Tunneling in Workbench 5.2.6 Alpha

+1

-0

posted by Jimmy Guerrero on Fri 23 Oct 2009 16:34 UTC
Tags:

(edit) mysql, Workbench, ssh

Given the announcement earlier this week of an updated release of the actively developed MySQL Workbench 5.2, I thought I'd give it a quick look...

Install on Windows went without a hitch.

One thing I noticed, which I don't remember being previously available in MySQL GUI tools, is the ability to connect to a remote MySQL server via SSH tunneling.

Below is a screen shot:

Well done! A small, but significant addition for folks that require SSH to connect to their systems.

I did notice that the design in Workbench involves selecting "Standard TCP/IP over SSH" from

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

Oracle MySQL Blogs

MySQL Links

Other Links

Planetarium

That's Impossible! How Can That Work?

MySQL Workbench 5.2 GA

MySQL Workbench 5.2 GA

MySQL Workbench 5.2 GA