I am not really a GUI DBA. They have their place and can do nice things but I just do not use them much. You can tell based on what I have upgraded.
The mysql-workbench does happen to be the latest version in the distro but the latest version is mysql-workbench-community-6.0.6-1.el6 . So I was curious after I saw the latest MySQL workbench blog post : http://mysqlworkbench.org/2013/08/mysql-workbench-6-0-6-ga-released/
So time to upgrade....
First, mysql-workbench-community is dependent on libtinyxml so you have to make sure that is installed or gets installed when you upgrade/install.
Others have dealt with this before :
So after I looked and found the tinyxml package...
Ok ... so it starts up and has a new look.
Being a shell geek I go to the shell first. Of course it complains that mysql-utilities are not installed. It can take you to the download page but might as well just go ahead of time because you might need to install the Connector-Python as well. So basically... go get these packages and install as well...
So... all of that and I have a GUI that opens a terminal window :)
So moving beyond that I started to look around.
The Administration has a nice new look with some decent graph information easily available for you.
The sakila model does look very nice though. The modeller is a handy feature in the GUI I do admit.
Well that is about all I did with the new MySQL workbench but I am upgraded now :)
# cat /etc/*-release
CentOS release 6.4 (Final)
# rpm -qa | grep MySQL
MySQL-server-5.6.13-1.el6.x86_64
MySQL-devel-5.6.13-1.el6.x86_64
MySQL-shared-compat-5.6.13-1.el6.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
MySQL-client-5.6.13-1.el6.x86_64
MySQL-shared-5.6.13-1.el6.x86_64
MySQL-test-5.6.13-1.el6.x86_6
# rpm -qa | grep mysql
php-mysql-5.3.3-23.el6_4.x86_64
mysql-workbench-gpl-5.2.47-1el6.x86_64
The mysql-workbench does happen to be the latest version in the distro but the latest version is mysql-workbench-community-6.0.6-1.el6 . So I was curious after I saw the latest MySQL workbench blog post : http://mysqlworkbench.org/2013/08/mysql-workbench-6-0-6-ga-released/
So time to upgrade....
First, mysql-workbench-community is dependent on libtinyxml so you have to make sure that is installed or gets installed when you upgrade/install.
Others have dealt with this before :
So after I looked and found the tinyxml package...
yum install tinyxml-2.6.1-1.el6.x86_64.rpm mysql-workbench-community-6.0.6-1.el6.x86_64.rpm
Installed:
mysql-workbench-community.x86_64 0:6.0.6-1.el6 tinyxml.x86_64 0:2.6.1-1.el6
Replaced:
mysql-workbench-gpl.x86_64 0:5.2.47-1el6
Complete!
Ok ... so it starts up and has a new look.
Being a shell geek I go to the shell first. Of course it complains that mysql-utilities are not installed. It can take you to the download page but might as well just go ahead of time because you might need to install the Connector-Python as well. So basically... go get these packages and install as well...
- http://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-1.0.12-1.el6.noarch.rpm/from/http://cdn.mysql.com/
- http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.3.4-1.el6.noarch.rpm/from/http://cdn.mysql.com/
mysql-connector-python-1.0.12-1.el6.noarch.rpm
mysql-utilities-1.3.4-1.el6.noarch.rpm
# yum install mysql-*.rpm
So... all of that and I have a GUI that opens a terminal window :)
The following MySQL Utilities are available:
Launching console ...
Utility Description
---------------- ---------------------------------------------------------
mysqlauditadmin audit log maintenance utility
mysqlauditgrep audit log search utility
mysqldbcompare compare databases for consistency
mysqldbcopy copy databases from one server to another
mysqldbexport export metadata and data from databases
mysqldbimport import metadata and data from files
mysqldiff compare object definitions among objects where the
difference is how db1.obj1 differs from db2.obj2
mysqldiskusage show disk usage for databases
mysqlfailover automatic replication health monitoring and failover
mysqlfrm show CREATE TABLE from .frm files
mysqlindexcheck check for duplicate or redundant indexes
mysqlmetagrep search metadata
mysqlprocgrep search process information
mysqlreplicate establish replication with a master
mysqlrpladmin administration utility for MySQL replication
mysqlrplcheck check replication
mysqlrplshow show slaves attached to a master
mysqlserverclone start another instance of a running server
mysqlserverinfo show server information
mysqluserclone clone a MySQL user account to one or more new users
So moving beyond that I started to look around.
The Administration has a nice new look with some decent graph information easily available for you.
The sakila model does look very nice though. The modeller is a handy feature in the GUI I do admit.
Well that is about all I did with the new MySQL workbench but I am upgraded now :)
