OurSQL Episode 152: Tooling Around, Part 2

This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.

Part 1 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

Percona University is coming to Washington, DC on Thursday, September 12th.

Upcoming MySQL events


MySQL Connect
is happening in San Francisco from Saturday September 21st - Monday September 23rd.

MySQL Tech Day in Paris Thursday Oct 10th

2nd MySQL, NoSQL and Cloud Conference & Expo Monday, October 14th through Wednesday October 16th, 2013 in Buenos Aires, Argentina.

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center.

Training
SkySQL Trainings
Tungsten University trainings
Oracle's MySQL Trainings
Percona Trainings

MySQL Utilities part 2
mysqldbcopy

mysqldbexport
Episode 145, where we talked about using mysqldump with the --tab option

mysqldbimport

mysqlfrm tool

mysqlserverinfo

# mysqlserverinfo  --server=root:passs@localhost --format=vertical
# Source on localhost: ... connected.
*************************       1. row *************************
         server: localhost:3306
        version: 5.6.12-log
        datadir: /var/lib/mysql/
        basedir: /usr
     plugin_dir: /usr/lib64/mysql/plugin/
    config_file: /etc/my.cnf
     binary_log: dev2-bin.000756
binary_log_pos: 89453607
      relay_log: dev2-relay-bin.000380
  relay_log_pos: 352985556
1 row.
#...done.

Ear Candy
In this week's Ear Candy, we talk about a problem installing MySQL Utilities on Ubuntu.

MySQL Utilities are installed under:
/usr/local/lib/python2.7/dist-packages/mysql/utilities/
while the connector was under:
/usr/lib/python2.7/dist-packages/mysql/connector/

Install the Connector and in the Python command line run the following sequence:
>>> import mysql.connector
>>> print mysql.connector.__file__
/usr/lib/python2.7/dist-packages/mysql/connector/__init__.pyc

Install the MySQL utilities and run the same command, now the path will begin with /usr/local/lib

Check sys.path in Python:

>>> import sys
>>> print sys.path
['', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages/PILcompat', '/usr/lib/python2.7/dist-packages/gst-0.10', '/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7', '/usr/lib/python2.7/dist-packages/ubuntu-sso-client', '/usr/lib/python2.7/dist-packages/ubuntuone-client', '/usr/lib/python2.7/dist-packages/ubuntuone-control-panel', '/usr/lib/python2.7/dist-packages/ubuntuone-couch', '/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol']

Notice that /usr/local/lib/python2.7/dist-packages is before the /usr/lib/pytho2.7/dist-packages, resulting in loading the utilities first and not recognizing the connector.

You can solve this issue with a symlink:

cd /usr/local/lib/python2.7/dist-packages/mysql
ln -sv /usr/lib/python2.7/dist-packages/mysql/connector/ connector

Now, if you try import mysql.utilities, followed by import mysql.connector and printing the __file__ property for both, it'll show that both are loading from the /usr/local/lib subtree.

At the Movies
This week we present A preview of the SkySQL data suite version 2 by Massimo Brignoli, Product Manager at SkySQL at the SkySQL and MariaDB Solutions Day 2013 that happened earlier this year.

Where you can see us
Sheeri will be at the September Boston MySQL User Group meeting on Monday September 9th.

We will both be speaking at MySQL Connect in San Francisco from Saturday September 21st - Monday September 23rd.

Sheeri will be at the Nagios World 2013 Conference in St. Paul, Minnesota on Monday, September 30th through Thursday, October 3rd.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1257