MySQL Bugs: #21238: Installing from source

Bug #21238	Installing from source
Submitted:	23 Jul 2006 10:00	Modified:	6 Sep 2006 10:25
Reporter:	Erik Wetterberg	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.1.11	OS:	Windows (windows)
Assigned to:	MC Brown	CPU Architecture:	Any

Description:
Tried the instructions in section 2.9.6 with the 5.1.11 release, which is the latest I can find. Can not find the win subdirectory in that release. Installation instructions are different in the release itself.  Nothing on the web page that says with MySQL version is needed. Also nothing in the changelog about changed installtion on windows.

Perhaps the right way to go is to forget about Visual Studio and use cygwin (or linux??) instead.

How to repeat:
Try the instructions in section 2.9.6 from the 5.1 reference manual on a clen windows installation, that is without mySQL installed. (and without cygwin etc..)

Suggested fix:
Add the win catalog to a distribution. Add instructions to the web page saying which version is required. Test the installation procedure.

Thank you for a problem report. Please, use separate Windows sources, with all needed components included: http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.11-beta-win-src.zip. Then follow steps outlined at http://dev.mysql.com/doc/refman/5.0/en/windows-vc-plus-plus-build.html. Inform about the results.

http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.11-beta-win-src.zip gives me a page not found error.

My first try was with the mysql-5.1.11-beta-win-src from the download page.

Sorry for misleading (I just removed my favotire mirror at the eand oF URL...). Please, use any mirror from those listed at 
http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.11-beta-win-src.zip/from/pick

OK, i have downloaded the source (mysql-5.1.11-beta-win-src) once again, but still there is no win subdirectory.  The procedure decsribed in the 5.0 documentation only supports Visual Studio 7.1, which is an old release, 2003. As far as I know this release is not available today.

What is available is the 8.0 release, also known as 2005. From this release I have downloaded Visual C++ Express Edition, which is free. According to the 5.1 documentation (http://dev.mysql.com/doc/refman/5.1/en/windows-source-build.html) Visual Studio 8 is supported, but you need the win subdirectory, and the win\build-vs8.bat command file to do this. I can not find this file in the zip file, which is release 5.1 (mysql-5.1.11-beta-win-src). Does this mean that you do not support Visual Studio 8 yet?

Are there any other options for me? Could I install cygwin and use Gnu CC? Or do I need to make a Linux partition on my PC?

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please, read note at http://dev.mysql.com/doc/refman/5.1/en/windows-source-build.html:
"Note: The instructions here are strictly for users who want to test MySQL on Windows from the latest source distribution or from the BitKeeper tree. For production use, MySQL AB does not advise using a MySQL server built by yourself from source. Normally, it is best to use precompiled binary distributions of MySQL that are built specifically for optimal performance on Windows by MySQL AB."

BK sources contain win directory. How to obtain BK source tree you can read here: http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html

OK, the option to use "a source distribution packaged by MySQL AB" does not work because the win subdirectory is not included in the windows distribution, but that is not a bug.

That's fine with me, since my aim is not to make you register bugs, but to get my development environment up and running, so I can add the storage engine we need. Seems like I need cygwin for that, and the Gnu CC compiler.  When I have installed this, can I use the Gnu CC compiler and skip Microsoft Visual Studio altogether?

See bug: http://bugs.mysql.com/bug.php?id=20907

We elaborate more your problem and find it is not well documented.

For compiling from source on Windows you should use UNIX sources (i.e. mysql-5.1.11-beta.tar.gz) or last BK sources and Visual Studio. Visual Studio 2005 is supported version. cygwin is not supported.

Thank you for the report.

The documentation for building from the 5.1 source tree (http://dev.mysql.com/doc/refman/5.1/en/windows-source-build.html) have been updated with the current build sequence.