You can build MySQL on Windows by using a combination of cmake and Microsoft Visual Studio .NET 2003 (7.1), Microsoft Visual Studio 2005 (8.0) or Microsoft Visual C++ 2005 Express Edition. You must have the appropriate Microsoft Platform SDK installed.
To compile from the source code using CMake
you must use the standard source distribution (for example,
build from the same distribution as used to build MySQL on
Unix, Linux and other platforms. Do not
use the Windows Source distributions as they do not contain
the necessary configuration script and other files.
Follow this procedure to build MySQL:
If you are installing from a packaged source distribution,
create a work directory (for example,
C:\workdir), and unpack the source
distribution there using WinZip or
another Windows tool that can read
files. This directory is the work directory in the following
If you are installing from a Bazaar tree, the root directory of that tree is the work directory in the following instructions.
Using a command shell, navigate to the work directory and run the following command:
If you have associated the
extension with an application such as a text editor, then
you may need to use the following command to force
configure.js to be executed as a
These options are available for
InnoDB storage engine.
ARCHIVE storage engine.
BLACKHOLE storage engine.
EXAMPLE storage engine.
FEDERATED storage engine.
Server suffix, default none.
Server comment, default "Source distribution".
Server port, default 3306.
For example (type the command on one line):
From the work directory, execute the
win\build-vs71.bat file, depending on
the version of Visual Studio you have installed. The script
invokes CMake, which generates the
mysql.sln solution file you will need
to build MySQL using Visual Studio..
You can also use
to build the 64-bit version of MySQL. However, you cannot
build the 64-bit version with Visual Studio Express Edition.
You must use Visual Studio 2005 (8.0) or higher.
From the work directory, open the generated
mysql.sln file with Visual Studio and
select the proper configuration using the
Configuration menu. The menu provides
MinRelInfo options. Then select
Build to build the solution.
The build process will take some time. Please be patient.
Remember the configuration that you use in this step. It is important later when you run the test script because that script needs to know which configuration you used.
You should test you build before installation. See Section 22.214.171.124, “Testing a Windows Source Build”.
To install, use the instructions in Section 126.96.36.199, “Installing MySQL from a Source Build on Windows”.