Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 64 Next 4 Older Entries

Displaying posts with tag: Workbench (reset)

Show your support for MySQL Workbench !
+1 Vote Up -1Vote Down

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
Employee +1 Vote Up -0Vote Down

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...]
Tech Writer Wanted for MySQL Workbench & Connectors
Employee +0 Vote Up -0Vote Down

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
Employee +2 Vote Up -0Vote Down
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
Employee +0 Vote Up -0Vote Down
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 Vote Up -0Vote Down
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 Vote Up -0Vote Down
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



  [Read more...]
How MySQL Workbench breaks itself
+6 Vote Up -0Vote Down
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!
Employee +5 Vote Up -0Vote Down

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


  [Read more...]
Sometimes, even a command line guy likes a GUI
+5 Vote Up -0Vote Down
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
Employee +2 Vote Up -0Vote Down
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 Vote Up -0Vote Down

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:

  [Read more...]
MySQL schema maintenance
+3 Vote Up -0Vote Down



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










  [Read more...]
Codebits 2009, coders conference and competition in Lisbon
+3 Vote Up -0Vote Down

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:

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





  [Read more...]
SSH Tunneling in Workbench 5.2.6 Alpha
Employee +1 Vote Up -0Vote Down
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...]
Free and easy schema diff and patch
+6 Vote Up -2Vote Down

The easiest way to see the differences between two schemas on a non-Windows machine is to run:

mysqldump -h server1 --no-data --all-databases > file1.sql
mysqldump -h server2 --no-data --all-databases > file2.sql
diff file1.sql file2.sql

However, this will show also trivial differences, such as the value of AUTO_INCREMENT. It also does not give you a way to patch one schema to be like another.

We frequently are asked to “do a schema diff and create a script that will ‘patch’ one server.” Usually this is done to take a development or test schema and move it to production for a release.

We like to use the best tool for the job, and while diff is good, I like to use MySQL workbench. The OSS (Community) edition provides



  [Read more...]
Workbench 5.2 Alpha
Employee +0 Vote Up -1Vote Down

In case you have not already noticed, Workbench 5.2 alpha / preview release of MySQL's premier development and design tool, has been announced.

For an independent preview, you can also see here

Workbench 5.2 Alpha
Employee +0 Vote Up -0Vote Down

In case you have not already noticed, Workbench 5.2 alpha / preview release of MySQL's premier development and design tool, has been announced.

For an independent preview, you can also see here

Workbench 5.2 Alpha
Employee +0 Vote Up -0Vote Down

In case you have not already noticed, Workbench 5.2 alpha / preview release of MySQL's premier development and design tool, has been announced.

For an independent preview, you can also see here

Workbench Rocking
Employee +1 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Workbench Rocking
Employee +0 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Workbench Rocking
Employee +0 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Double Free
Employee +0 Vote Up -0Vote Down

MySQL Workbench has already received some great accolades this year and there is more to come!

Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.

The Conference (http://www.mysql.com/news-and-events/users-conference/" target="_blank) will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara Ballroom.


  [Read more...]
Double Free
Employee +0 Vote Up -0Vote Down

MySQL Workbench has already received some great accolades this year and there is more to come!

Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.

The Conference (http://www.mysql.com/news-and-events/users-conference/" target="_blank) will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara


  [Read more...]
Double Free
Employee +0 Vote Up -0Vote Down

MySQL Workbench has already received some great accolades this year and there is more to come!

Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.

The Conference (http://www.mysql.com/news-and-events/users-conference/" target="_blank) will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara


  [Read more...]
workbench-5.1.1-alpha on Fedora 9
+0 Vote Up -0Vote Down

So, you want to compile Workbench for Linux, on Fedora 9. You need to install the following packages:


autoconf automake libtool libzip-devel libxml2-devel libsigc++20-devel libglade2-devel gtkmm24-devel mesa-libGLU-devel mysql-libs mysql mysql-devel uuid-devel lua-devel glitz-devel glitz-glx-devel pixman-devel pcre-devel libgnome-devel gtk+-devel pango-devel cairo

I feel I’m being too liberal with dependencies, but I’m not about to strip it, I just want to get it working first :)

You need to have ctemplate and ctemplate-devel installed from updates-testing-newkey (relevant koji build log).

By default, configure.in in Workbench looks for “google-ctemplate”, as opposed to just “ctemplate” as



  [Read more...]
Workbench on Linux
+0 Vote Up -0Vote Down

I had the pleasure of sitting right across the MySQL GUI Tools Team, and decided to try my hand at Workbench (Workbench for Linux, that is). Congratulations to the entire team for the great work! I am excited.

First up, the things you need on Ubuntu 8.04 (I created a fresh install, and installed all the updates), if you’re downloading the binary:

  • liblua5.1-0
  • libglitz1
  • libzip1
  • libmysqlclient15off
  • mysql-common
  • libglitz-glx1



Workbench on Linux

It works. It starts up. Its exciting. Of course, when I try to edit a table name or even create a table, it fails by




  [Read more...]
Webinar: Introducing MySQL Workbench
+0 Vote Up -0Vote Down

September 16, 10:00 am PST, 1:00 pm EST, 18:00 GMT



I'm proud to inform you that I will be hosting a MySQL Workbench Webinar, September 16. You can find the announcement right here (http://www.mysql.com/news-and-events/web-seminars/display-196.html" target="_wb).

I have spent quite a deal of time testing MySQL Workbench. Thanks to the hard work of the MySQL Developer Tools Team, the tool just becomes better and better each new build. Personally, I think it is high time to present its features and benefits in a web seminar, and when Giuseppe asked me to do it, I was more than happy to oblige.





  [Read more...]
MySQL Workbench Italian Webinar, On-Demand!
+0 Vote Up -0Vote Down

Finally the on-demand version of the web based seminar is online. You can find recording here  (http://www-it.mysql.com/news-and-events/on-demand-webinars/display-od-156.html%20)and you can also download presentation slides.

Please note that due to a technical problem in the time span  11:10 - 13:20 slides are not visible, but audio is good. Sorry for the inconvenience and thanks to everyone who attended!

MySQL Workbench Italian Webinar, On-Demand!
+0 Vote Up -0Vote Down

Finally the on-demand version of the web based seminar is online. You can find recording here  (http://www-it.mysql.com/news-and-events/on-demand-webinars/display-od-156.html%20)and you can also download presentation slides.

Please note that due to a technical problem in the time span  11:10 - 13:20 slides are not visible, but audio is good. Sorry for the inconvenience and thanks to everyone who attended!

Previous 30 Newer Entries Showing entries 31 to 60 of 64 Next 4 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.