Statically Linking With The mySQLAPI

[SpiderHawk]

I have written a program which performs basic actions on a mySQL database. This program is intended to be run on my web host's server, but does not have the required files to compile on that machine or use a dynamically linked executable on there.

Thus I am left with having to compile a statically linked version on my local machine and upload from there.

I'm having great difficulty in compiling it this way though.

I do this:

g++ -static generaltest.cpp -ogentest -L /usr/lib/mysql -lmysqlclient

But get this:

/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
my_compress.o(.text+0x13c): undefined reference to `compress'
collect2: ld returned 1 exit status

Scary! This doesn't happen when I do not use the -static though. Am I doing something wrong?


Any help on what I need to do would be greatly appreciated.

[Boksha]

The only thing I could think up (and it's probably wrong) is that the library you are linking to is just a reference to a dynamicly linked library, so the functions aren't really in the library, just the commands to import them. I have no idea how to fix that though.