Methods for compiling MYSQL5.1.48 in VS2008

1. Download MYSQL5.1.48 source code, CMAKE, VS2008

2. Install CMAKE and VS2008, decompress MYSQL5.1.48 to D:\mysql

3. Open CMD; CD D:\mysql

4. Run the command in CMD: wscript win\ WITH_INNOBASE_STORAGE_ENGINE WITH_PARTITION_STORAGE_ENGINE MYSQL_SERVER_SUFFIX=-pro

5. Run the command in CMD: win\

6. Use ULTRA EDIT to open the D:\mysql\sql\sql_local.cc file, save as UTF-8 format, overwrite the original file

7. Modify the test_lc_time_sz function in file D:\mysql\sql\ and change the code

if ((*loc)->max_month_name_length != max_month_len ||

(*loc)->max_day_name_length != max_day_len)

{

DBUG_PRINT("Wrong max day name(or month name) length for locale:",

("%s", (*loc)->name));

DBUG_ASSERT(0);

}

Comment

8. Copy the entire folder D:\mysql\win\data to D:\mysql\sql

9. Open D:\mysql\ with VS2008, compile the code, and execute the mysqld project

10. Open D:\mysql\client\Debug\, this is a client tool, equivalent to ORALCE's SQLPLUS

11. Execute the statement SHOW DATABASES in it and perform the test.