Can MySql have multiple datadir's ?

[Tony Baker]

Hi, we have several dozen clients and it would be nice to have a
seperate folder structure for each one, as we zip up data and send it
off to them and we can't have the possibility of accidently sending
other clients data.

We can have a seperate database for each client, but what would be
really nice is to be able to have several different mysql "data"
folders (one for each client) but have MySql be aware of all of
them...

Is this possible?

Cheers,

Tony.

[steve]

"Tony Baker" wrote:

Hi, we have several dozen clients and it would be nice to have a
seperate folder structure for each one, as we zip up data and send it off to them and we can’t have the possibility of accidently
sending
other clients data.

We can have a seperate database for each client, but what would be
really nice is to be able to have several different mysql "data"
folders (one for each client) but have MySql be aware of all of
them...

Is this possible?

Cheers,

Tony.

Tony, in Linux you can have data bases in diff. directories, and
manage that thru symbolic links. Search for "mysql symbolic link"
on google/SE.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-multip...ict133540.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=459837

[steve]

"Tony Baker" wrote:

Hi, we have several dozen clients and it would be nice to have a
seperate folder structure for each one, as we zip up data and send it off to them and we can’t have the possibility of accidently
sending
other clients data.

We can have a seperate database for each client, but what would be
really nice is to be able to have several different mysql "data"
folders (one for each client) but have MySql be aware of all of
them...

Is this possible?

Cheers,

Tony.

Tony, in Linux you can have data bases in diff. directories, and
manage that thru symbolic links. Search for "mysql symbolic link"
on google/SE.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-multip...ict133540.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=459837