mysql_connect

> (2) Assuming the answer to (1) is yes, any idea why loading the mysql
> interface using the command [...]
>
>     ;; Loading #p"/opt/lisp/clsql-1.8.8/db-mysql/mysql-api.x86f".
>     Undefined foreign symbol: "mysql_connect"

From http://www.mysql.com/doc/en/Upgrading-from-3.23.html

  "The old C API functions mysql_drop_db(), mysql_create_db(), and
   mysql_connect() are no longer supported unless you compile MySQL with
   CFLAGS=-DUSE_OLD_FUNCTIONS. However, it is preferable to change client
   programs to use the new 4.0 API instead."

From the MySQL C API:

http://www.mysql.com/doc/en/mysql_create_db.html

  "This function is deprecated. It is preferable to use mysql_query() to
   issue an SQL CREATE DATABASE statement instead."

http://www.mysql.com/doc/en/mysql_drop_db.html

  "This function is deprecated. It is preferable to use mysql_query() to
   issue an SQL DROP DATABASE statement instead."

http://www.mysql.com/doc/en/mysql_connect.html

  "This function is deprecated. It is preferable to use
   mysql_real_connect() instead."

Cheers,
Marcus
--