importing MySQLdb

[Ned Deily]

In article <4EFB9D6D.3080506 at gmail.com>,
 Dilara Ally <dilara.ally at gmail.com> wrote:
> I'm trying to import the MySQLdb for python.  I downloaded the proper 
> setuptools egg (ver2.7) for a Mac with OSX10.6
> 
> I then downloaded the MySQL-python-1.2.3 and ran the following commands
> 
> python setup.py build
> sudo python setup.py install
> 
> Then to test that the module was properly loaded I used the interactive 
> python prompt ad ran the following command:
> 
> import MySQLdb
> 
> The error message read:
> 
> Traceback (most recent call last):
>    File "<stdin>", line 1, in <module>
>    File "MySQLdb/__init__.py", line 19, in <module>
>      import _mysql
>    File "build/bdist.macosx-10.6-intel/egg/_mysql.py", line 7, in <module>
>    File "build/bdist.macosx-10.6-intel/egg/_mysql.py", line 6, in 
> __bootstrap__
> ImportError: 
> dlopen(/Users/dally/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-intel.eg
> g-tmp/_mysql.so, 
> 2): Library not loaded: libmysqlclient.18.dylib
>    Referenced from: 
> /Users/dally/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-intel.egg-tmp/_
> mysql.so
>    Reason: image not found
> 
> Does anyone have any ideas on how to fix this problem?  Any help will be 
> greatly appreciated!

If you installed the MySQL client libraries from a MySQL binary 
installer, chances are that the library name in the client library does 
not contain the full path.  The MySQL project has a pretty dismal record 
for releasing faulty OS X binaries.  There are a few workarounds, the 
best being either to use install_name_tool to fix the path or to set the 
DYLD_LIBRARY_PATH environment variable.  See, for example, this blog 
post:

http://www.blog.bridgeutopiaweb.com/post/how-to-fix-mysql-load-issues-on-
mac-os-x/

-- 
 Ned Deily,
 nad at acm.org