View source

'''Prerequisites:'''
*Download MySQL Installer: http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.34-win32.msi
**Install MySQL by executing mysql-5.1.34-win32.msi
*Download MySQL Source: http://downloads.mysql.com/archives/mysql-5.1/mysql-noinstall-5.1.34-win32.zip
**Unzip mysql-noinstall-5.1.34-win32.zip to any directory
**Copy the following folders to the "C:\Program Files\MySQL\MySQL Server 5.1" folder (or wherever you installed MySQL)
***data
***Embedded
***include
***lib
***mysql-test
***sql-bench
*Install Visual Studio 2005 or 2008 (VS 2008 untested but should work)
*Instal Python 2.6

'''1) Get MySQL-Python module source:'''
*Download from: http://sourceforge.net/project/downloading.php?group_id=22307&filename=MySQL-python-1.2.2.tar.gz&a=82786512
*Extract to folder: MySQL-python-1.2.2 

'''2) Install Python's setuptools module:'''
*Download these two files and put them into the same directory:
**http://pypi.python.org/packages/2.6/s/setuptools/setuptools-0.6c9-py2.6.egg#md5=ca37b1ff16fa2ede6e19383e7b59245a
**http://peak.telecommunity.com/dist/ez_setup.py
*Open a command prompt in this directory and type "python ez_setup.py setuptools-0.6c9-py2.6.egg"

'''3) Build MySQL-Python module:'''
*If you are using Visual Studio 2005, tweak environment:
**make sure "vsvars32.bat" exists in "C:\Program Files\Microsoft Visual Studio 8\Common7\Tools"
**create the environmental variable "VS90COMNTOOLS" with the value "C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\"
**Restart PC
*Edit "MySQL-python-1.2.2/ez_setup.py" file:
**On or around line 17 you will find this:<pre>DEFAULT_VERSION = "0.6c5"</pre>
**Change it to this:<pre>DEFAULT_VERSION = "0.6c9"</pre>
*Edit "MySQL-python-1.2.2/site.cfg" file:
**On or around line 18 you will find this:<pre>registry_key = SOFTWARE\MySQL AB\MySQL Server 5.0</pre>
**Change it to this:<pre>registry_key = SOFTWARE\MySQL AB\MySQL Server 5.1</pre>
*Edit "MySQL-python-1.2.2/_mysql.c" file:
**On or around line 31 you will find this: <pre>#if defined(_WIN32) || defined(_WIN64) || defined(__WIN32__) || defined(WIN32) || defined(MS_WIN32)&#013;#include <windows.h></pre>
**Change it to this:<pre>#if defined(_WIN32) || defined(_WIN64) || defined(__WIN32__) || defined(WIN32) || defined(MS_WIN32)&#013;#include <winsock2.h>&#013;#include <windows.h></pre>
*Open command prompt in MySQL-python-1.2.2 folder
*Type "setup.py build"
**Note: You will probably get a bunch of warnings and maybe a manifest error, these are ok as long as there are no errors in compiling or linking.
**Note: This will generate the "MySQL-python-1.2.2/build" folder
*Type "setup.py bdist_wininst"
**Note: This will generate the "MySQL-python-1.2.2/dist" folder

'''4) Install MySQL-Python module:'''
*Execute "MySQL-python-1.2.2/dist/MySQL-python-1.2.2.win32-py2.6.exe"