Archive for the ‘Tutorial’ Category
Wednesday, June 19th, 2013
The home screen of MySQL Workbench is the first thing you see when you start up the application and it's therefor an important hub to quickly reach important parts or do repeating tasks like opening certain connections. This article describes the home screen in some detail with additional info and ...
Posted in Tutorial | No Comments »
Tuesday, June 18th, 2013
Brandon Johnson at Mozilla has posted a nice tip on how to use MySQL Workbench SSH tunneling with MySQL servers configured to accept only Unix Socket File connections (no TCP/IP). Head over there for more info about how to use the "socat" utility to bridge a SSH tunnel from WB ...
Posted in Community, Tutorial | No Comments »
Monday, February 18th, 2013
In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that's OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?
It turns out ...
Posted in Linux, Mac, Migration, Tutorial | No Comments »
Wednesday, November 21st, 2012
MySQL Workbench 5.2.41 introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. As of Workbench 5.2.44 you can migrate databases from Microsoft SQL Server, PostgreSQL and Sybase Adaptive Server Enterprise. It also provides for generic migrations, i.e. ...
Posted in Migration, Tutorial | 2 Comments »
Wednesday, July 25th, 2012
MySQL Workbench 5.2.41 introduces a new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as ...
Posted in Administration, Migration, Tutorial, Windows | 14 Comments »
Monday, October 17th, 2011
To build MySQL Workbench one would need to install dependencies, fetch source code, configure it and actually do a build.
Note: On a Core2 Quad 2.4 GHz and a 4G of RAM it takes about 30-40 minutes to build Workbench. Also it uses about 4.2G of hdd space to build.
Here are ...
Posted in Linux, Tutorial | 20 Comments »
Friday, March 4th, 2011
Recently I had to test MySQL Workbench against fresh version of the server. Naturally, the default mysql-server was already installed from repository of my Linux distro. So I installed the latest server version into my /opt/server directory. And then I had several points to resolve, for example, how to start ...
Posted in Administration, Linux, Tutorial | 1 Comment »
Monday, December 13th, 2010
The MySQL team has been continuously improving its products on the Windows platform. Along this line, we've responded to a request from our users of Workbench on Windows - to provide remote access to Windows Servers using Windows management methods - as an alternative to SSH.
Managing a MySQL server obviously requires ...
Posted in Tutorial, Windows | 15 Comments »
Thursday, December 9th, 2010
MySQL has the well earned reputation for ease-of-use and "15-minutes-to-success", since we continually focus making the server easy to use. MySQL Workbench provides the visual tools for database design, development, and administration. However, many DBAs prefer using the command-line, and there are many tasks that require the creation ...
Posted in Coding, Community, Plugins, Tutorial | 6 Comments »
Wednesday, November 3rd, 2010
To automatically create Foreign Key relationships is a typical use case for developers working with the MyISAM storage engine. This has been a popular topic on the Blog and forums so we’re revisiting it here - with a new and improved plugin written in Python.
While the InnoDB storage engine supports ...
Posted in Coding, Plugins, Tutorial | 22 Comments »
