Many database - can they have many separate directories?

[googleboy]

Hi there.

I am planning a conversion from c-isam to mysql (or possibly postgres)
and I am wondering if it would be possible to keep the same directory
structure for my db's at the moment - which is to say that we have
around 700 separate databases (one for each client) and I have them
all separated off into their own little subdirectory.

Preliminary reading of the list, Paul DuBois' book and Michael
Kofler's book didn't really have much to say on the matter. I think
they just expect me to be okay putting them all in one place...?

TIA

googleboy

[Bill Karwin]

googleboy wrote:

we have
around 700 separate databases (one for each client) and I have them
all separated off into their own little subdirectory.

MySQL typically has a directory for all databases, and each database is
in a subdirectory off of the data home.

You can specify the location of the default data home when you build
from source:
../configure --localstatedir=/usr/local/mysql/data

Or you can specify the data directory when you start mysqld, either with
command-line options or with an entry in the global my.cnf file. I
recall the option is `datadir'. As far as I know, each running instance
of mysqld can have only one data directory.

Refer to the documentation for more information.

Bill

[pan]

"googleboy" <my******@yahoo.com> wrote in message
news:e8**************************@posting.google.c om...

Hi there.

I am planning a conversion from c-isam to mysql (or possibly postgres)
and I am wondering if it would be possible to keep the same directory
structure for my db's at the moment - which is to say that we have
around 700 separate databases (one for each client) and I have them
all separated off into their own little subdirectory.

Preliminary reading of the list, Paul DuBois' book and Michael
Kofler's book didn't really have much to say on the matter. I think
they just expect me to be okay putting them all in one place...?

TIA

googleboy

softlinks for *nix-like OS