2 questions:

- How do I access MySql from within a C/C++ program (without invoking
the unix shell, i.e. without calling "system" or "popen"?
- How do I tell MySql I want my database to be stored in a specific
location on my file system?

lalawawa wrote:
http://dev.mysql.com/doc/refman/5.5/...cfunction.html

http://dev.mysql.com/doc/refman/5.5/...all-mysql.html

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Link with libmysqlclient and code calls using the C or C++ API into
your program. See the section of the MySQL manual on the programming
APIs.

You don't really get fine-grained control over this. You can set
datadir (in my.cnf) to set the location of the whole tree of
databases. You can locate an individual (MyISAM) database elsewhere
by replacing a subdirectory of datadir with a symlink to a directory
placed where you want it to go. (Careful about preserving ownerships
and permissions if you do such a copy, and do it when the server
isn't running.)

lalawawa <usenet (AT) ccjj (DOT) info> wrote:
There is a bunch of "connectors" available to use MySQL from many
programming languages. The C API (also known as libmysqlclient) is
used very often. Connector/C is just a freestanding implementation of
the same. The C++ API is from MySQL^WSun^WOracle, and Connector/C++
is a community project.

http://dev.mysql.com/doc/refman/5.1/...tors-apis.html

The datadir option has been named already. There are also options for
CREATE TABLE to put MyISAM files outside $datadir. And the shared
InnoDB tablespace can also be put outside the $datadir.

http://dev.mysql.com/doc/refman/5.1/...r-options.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html
http://dev.mysql.com/doc/refman/5.1/...arameters.html


XL