At 20:47 27/03/2001 +0300, Yusuf Incekara wrote:
Hi!
Actually the MySQL Win32 distribution doesn't provides yet,
the binaries and the source for BDB and Innobase stuffs.
However if you want to build yourself a MySQL server with the support of
BDB tables, below the instructions to build a server for the NT platform
(as example):
You need to have:
- The VC++ 6.0 Compiler.
- The Microsoft Macro Assembler compiler 5.10 (not mandatory).
- The source for MySQL Win32: mysql-3.23.36-win-src.zip
- The source for Unix: mysql-3.23.36.tar.gz to obtain the source for BDB
tables.
Building the MySQL Server
- Unpacked the mysql-3.23.36-win-src.zip file on our working
directory e.g: c:\3.23.36.
- Unpacked the mysql-3.23.36.tar.gz on any temporary directory.
e.g.: c:\mysql-3.23.36
- Run the VC++ 6.0 compiler.
- With the menu: Tools/Options, add the following paths:
C:\MYSQL-3.23.36\BDB\BUILD_WIN32
C:\MYSQL-3.23.36\BDB\INCLUDE
- Open the workspace: C:\MYSQL-3.23.36\BDB\build_win32\Berkeley_DB.dsw
- Accept the option to convert the project to the VC++ 6.0 version.
- Using the menu Build/Set Active Configuration, set the project:
db_buildall - Win32 Release Static.
- Press F7 to build the BDB stuff.
- Close the workspace Berkeley_DB.dsw.
- Create the directory: c:\3.23.36\lib_release and copy into it, the
C:\MYSQL-3.23.36\BDB\build_win32\Release_static\libdb32s.lib file.
- Open the workspace c:\3.23.36\mysql.dsw.
- Set the mysqld- Win32 nt as active project.
- Open the settings screen for the mysqld files.
- Click over the C/C++ tab and add the following preprocessor definition:
HAVE_BERKELEY_DB
- Click over the Link tab and change the name of the output file:
../client_release/mysqld-max-nt.exe
- Add to the Object/library modules: ..\lib_release\libdb32s.lib
- Close the setting screen.
- Add the file c:\3.23.36\sql\ha_berkeley.cpp to the mysqld files tree.
- Press F7 to build the MySQL server.
Now you can use the mysqld-max-nt.exe:
C:\>cd\mysql\bin
C:\mysql\bin>mysqld-max-nt --install
C:\mysql\bin>net start mysql
The MySql service was started successfully.
C:\mysql\bin>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> create table mybdb (id int not null primary key, idname char(50))
-> type=bdb;
Query OK, 0 rows affected (0.72 sec)
Note:
If you don't have the masm.exe compiler, you remove the *.asm files
(2) from the strings tree and add the files from the strings tree
claimed by the link process.
Regards,
Miguel
>Tha instructions on mysql web pages ,
>downloaded documents and
>relelased product versions are not the same for Windows.
>I still could not understand did 3.23.35a or 3.23.36
>support bdb on windows and if
>supports how can i implement this.
>
>Regards.
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
