I found it:

Import "-L/usr/local/mysql/lib -lmysqlclient -lz -lsystemstubs"
Import "mysql.cpp"

This will compile and link on a PowerPC Mac with MySQL 5.0.24.

The only problem: It does not seem to work anyhow.

I tried this to connect to a local MySQL server:

Local conn:ISQLDB=SetISQLDBDriver(GetMySQLDBDriver(True,"localhost","root","","mysql"))
Local result:ISQLResult=conn.execute("SELECT * FROM db")

But result is null, even though this should return something.

Maybe I will find an answer to that as well. For today, I´m tired enough. ;-)

Greetz,
Winni

First I would like to thank gman for his great work on this module - this is really helpful!

I have not yet looked thoroughly at the module for PostgreSQL (but will do it this weekend). However, I have the same problem as gavinb with _compress and _uncompress - but on Mac OS X (Intel), and importing ZLib does not fix it.

Do you have any suggestions what to do about it?

Thanks and greetings from Germany,
Winni

next you'll need to edit mysql.cpp in the mysql.mod folder and comment out the #include <winsock.h> and save the file.

next edit the mysql.bmx in the same directory and add:

?Linux
Import "-lz"
?

just above:

Import "-lmySQL"
Import "mysql.cpp"

then save the file and compile modules.  those are all the steps i took and it works fine

?Linux
Import "-lz"
?
Import "-lmySQL"
Import "mysql.cpp"

gets rid of errors, now it works A.OK, thanks dude

?Linux
Import Pub.ZLib
?

so the end result would look like:

Import Pub.ISQLDB
Import BRL.Blitz

?Linux
Import Pub.ZLib
?
Import "-lmySQL"
Import "mysql.cpp"

if that doesnt work, try:

Import Pub.ISQLDB
Import BRL.Blitz

?Linux
Import "-lz"
?
Import "-lmySQL"
Import "mysql.cpp"

Building main
Compiling:main.bmx
flat assembler  version 1.64
4 passes, 19935 bytes.
Linking:main.debug
/usr/lib/libmySQL.a(my_compress.o)(.text+0x66): In function `my_uncompress':
: undefined reference to `uncompress'
/usr/lib/libmySQL.a(my_compress.o)(.text+0x11c): In function `my_compress_alloc':
: undefined reference to `compress'
collect2: ld returned 1 exit status
Build Error: Failed to link /home/gavin/Desktop/game/main.debug
Process complete