Hi there
I have managed to follow your instructions, I have used the BDB source files
from the Unix download (build_win32 directory). And I have used the Windows
Source Files for MYSQL. Everything appears to compile correctly without any
errors, however when trying to do a "net start mysql" I get an error, upon
doing a debug I find the error happens on the following line which I
obtained from the Disassembly window (I do apologize, I am a VB programmer
and therefore a little unfamiliar with C++)
77F8E30E int 2Eh
Does this help anyone at all, to explain why when issuing a net start ,
mysql crashes.
Below is a few more lines from the dissambelly window, with the faulty one
appearing about half way through as per above
77F8E27B mov dword ptr [ebx+0B0h],0
77F8E285 mov dword ptr [ebx+0ACh],0
77F8E28F mov dword ptr [ebx+0A8h],0
77F8E299 mov dword ptr [ebx+0A4h],0
77F8E2A3 mov dword ptr [ebx+0A0h],0
77F8E2AD mov dword ptr [ebx+9Ch],0
77F8E2B7 mov word ptr [ebx+0BCh],cs
77F8E2BD mov word ptr [ebx+98h],ds
77F8E2C3 mov word ptr [ebx+94h],es
77F8E2C9 mov word ptr [ebx+90h],fs
77F8E2CF mov word ptr [ebx+8Ch],gs
77F8E2D5 mov word ptr [ebx+0C8h],ss
77F8E2DB pushfd
77F8E2DC pop dword ptr [ebx+0C0h]
77F8E2E2 mov eax,dword ptr [ebp+4]
77F8E2E5 mov dword ptr [ebx+0B8h],eax
77F8E2EB mov eax,dword ptr [ebp]
77F8E2EE mov dword ptr [ebx+0B4h],eax
77F8E2F4 lea eax,[ebp+8]
77F8E2F7 mov dword ptr [ebx+0C4h],eax
77F8E2FD pop ebx
77F8E2FE ret 4
77F8E301 mov eax,dword ptr [ebp+4]
77F8E304 ret
77F8E305 mov eax,9Fh
77F8E30A lea edx,[esp+4]
77F8E30E int 2Eh
77F8E310 jmp 77F98BAD
77F8E315 imul esi,ebx
77F8E318 add esi,ecx
77F8E31A mov dword ptr [ebp-4],esi
77F8E31D mov si,word ptr [edi]
77F8E320 inc edi
77F8E321 inc edi
77F8E322 push 4
77F8E324 push esi
77F8E325 call 77F873D4
77F8E32A pop ecx
77F8E32B test eax,eax
77F8E32D pop ecx
77F8E32E je 77F8E3CA
77F8E334 movzx ecx,si
77F8E337 sub ecx,30h
77F8E33A cmp ecx,ebx
Regards
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Miguel Angel Solórzano
> Sent: 24 April 2001 12:50
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Compiling MYSQL for Win32 Platform & BDB
>
>
> At 00:27 24/04/01 +0200, Warren van der Merwe wrote:
> Hi!
> Below the instructions that I sent some time ago, only change the
> version mentioned by the new ones that you have.
>
> Regards,
> Miguel
>
> Assuming that you have on hand:
>
> - The db-3.2.9 source stuff
> - The MySQL 3.23.36 source stuff
> - The VC++ 6.0 compiler
>
> 01.- Unpacked the db-3.2.9.zip file e.g.: c:\db-3.2.9
> 02.- Unpacked the mysql-3.23.36-win-src.zip file e.g.: c:\3.23.36
> 03.- Create the directory: c:\3.23.36\lib_release
> 04.- Build the BDB stuff:
>
> Run the VC++ Compiler.
> Using File/Open Workspace menu, open the workspace
> c:\db-3.2.9\build_win32\Berkeley_DB.dsw.
> When prompted to convert the project for the new version,
> click Yes.
> Open the screen Options by selecting: Tools/Options menu.
> Click the Directories tab and you add the below directories:
>
> C:\DB-3.2.9\BUILD_WIN32
> C:\DB-3.2.9\INCLUDE
>
> Now open the Set Active Project Configuration screen by
> selecting the Build/Set Active Configuration menu.
> Select the configuration called: db_buildall - Win32 Release Static
> pressing the Ok button.
> Press the F7 button to begin the compile process until see the
> message: db_buildall.exe - 0 error(s), 0 warning(s).
> Close the workspace.
> Copy the lib c:\db-3.2.9\build_win32\Release_static\libdb32s.lib to
> the directory c:\3.23.36\lib_release.
>
> 05.- Build the MySQL Server
>
> Open the workspace c:\3.23.36\mysql.dsw.
> You need to have the Microsoft Macro Assembler compiler 5.10 already
> in the environment path. That is necessary to build the Strings.asm
> and the Strxmov.asm from the strings tree. Otherwise, if you don't
> have the masm.exe compiler, remove these 2 files from the strings tree
> and add the following files to the strings project:
>
> \strings\strmov.c
> \strings\strend.c
> \strings\strxmov.c
> \strings\strmake.c
> \strings\is_prefix.c
> \strings\strnmov.c
> \strings\strnlen.c
> \strings\bmove_upp.c
> \strings\strcend.c
> \strings\strfill.c
>
> Now, select the active configuration called mysqld- Win32 nt.
> You can select other configuration option e.g.: mysqld.
> Right click the mysqld files project and select Add Files to project.
> Add the file c:\3.23.36\sql\ha_berkeley.cpp
> Open the mysqld files settings screen. Click over the C/C++ tab.
> Add the Preprocessor definition: HAVE_BERKELEY_DB
> Now click the link tab and change the name for the output file
> e.g.: ../client_release/mysqld-max-nt.exe
> On the Object/Library modules, add the ..\lib_release\libdb32s.lib
> Close the last screen mentioned.
> Press F7 to build the MySQL Stuff and wait until see the message that
> the mysqld-max-nt.exe file was copied.
>
> 3. Working with the MySQL Server
>
> If you have already a server running, stop it and remove its service:
> C:\mysql\bin>net stop mysql
> The MySql service is stopping............
> The MySql service was stopped successfully.
>
> C:\mysql\bin>mysqld-nt --remove
>
> Copy the mysqld-max-nt.exe to the /mysql/bin directory.
>
> C:\mysql\bin>mysqld-max-nt --install
>
> C:\mysql\bin>net start mysql
>
> The MySql service was started successfully.
> C:\mysql\bin>mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.35a
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql> use test;
> Database changed
> mysql> create table mybdb (id int not null primary key,
> idname char(50))
> -> type=bdb;
> Query OK, 0 rows affected (0.77 sec)
>
>
>
>
>
>
>
>
>
>
> >Hi there
> >
> >I have both the patched source for BDB and the Win32 source
> for MySql. So
> >now the next logical step is to compile them right? So I
> compile them, but
> >one thing is lurking in the back of my mind, how do I set
> the MYSQL up to
> >use the BDB table type? When I try and create a table and
> set the type to
> >BDB, it defaults to MYISAM. What am I missing. In all
> honesty this has been
> >a huge learning curve for me, I feel like I am almost there,
> and just need a
> >little more help.
> >
> >Anymore's assistance will be greatly appreciated
> >
> >Thanks
> >Warren
> >
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >Warren van der Merwe
> >Software Director
> >PRT Trading (Pty) Ltd t/a RedTie
> >Cell (083) 262-9163
> >Office (031) 767-0249
> >
> >
> >
> >---------------------------------------------------------------------
> >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
>
>
>
---------------------------------------------------------------------
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
