MySQL-Python 1.0.0 for win32 Notes:

June 28 2004
I needed to get mysql-python working for win32, so I compiled it. I know a lot of people are looking for this, so enjoy... With 0.9.2, BLOBs weren't working properly for me, ZMySQLDA wasn't working without being
patched and transaction support ( using the + ) wasn't working.  This version resolves all those issues and works for me on XP/Plone2.03/Zope2.7. However, you should consider it untested/unsupported, so use at your own risk.

Installation Notes:

There is no installer - extract and put the files in your Python\Lib\site-packages directory.

Compile notes:

Linked against MySQL 4.0.17 &  Python 2.3.3

How to compile on Windows:

Requirements:

MS Visual C++ 6.0
Python 2.3.3 or newer
MySQL 4.0.17 or newer


Quick Build HOWTO

1. Optional: Get mingw/gcc. You may need it to build .def or .a files
2. Make sure you have all the lib files  - zlib, msvcrt, crypt32 & mysqlclient.lib
3. Modify setup.py for your include&lib paths; also change libraries.append("crypt") to  libraries.append("crypt32")
4. Compile from the command line in MS VC++ 6 (needed since Python & MySQL both use this tool)

C:\Program Files\Microsoft Visual Studio\VC98\Bin\VCVARS32.BAT   (set vc++ paths)
c:\[..\build-dir]> set PATH=%PATH%;[python-dir]
c:\[..\build-dir]> python setup.py build



Credits:
Andy's work - http://sourceforge.net/projects/mysql-python/


*rant - It is unfortunate that you need to compile this in MS Visual C rather than with gcc/mingw. I wasted a lot of time trying to get it to link in gcc before giving up in disgust and grabbing an old VC++ from work. oh well...


--Aaron Fosdick  -- aaron /lkj/ at /87%\/ hypervision.com