Hello all,
I have MySQL installed on a Mandrake Linux system, it is installed on
the /usr partition.
I was wondering, is it possible to store some databases on the /var
partition while MySQL is installed on the /usr partition?
And, if it is possible, can you store DB_A on /usr and DB_B on /var
On Wed, 3 Nov 2004, Yves Arsenault wrote:
Hello all,
I have MySQL installed on a Mandrake Linux system, it is installed on
the /usr partition.
I was wondering, is it possible to store some databases on the /var
partition while MySQL is installed on the /usr partition?
Yes. In fact,
Thanks for the reply,
Is there any information on the mysql.com website on how to store data
on 2 separate partitions?
I'll be doing a bit of research on this soon...
Thanks again,
Yves
On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas [EMAIL PROTECTED] wrote:
On Wed, 3 Nov 2004, Yves
On Wed, 3 Nov 2004, Yves Arsenault wrote:
Thanks for the reply,
Is there any information on the mysql.com website on how to store data
on 2 separate partitions?
There is something in the manual. The title is 'Symbolic links to
databases'.
quote
Using Symbolic Links
Ah,
Thank you all so much.
:-)
My purpose for asking was some concerne with the possibility of
growing DB sizes..
Question answered.
Score one for the list.
Yves
On Wed, 3 Nov 2004 14:52:35 +0100 (CET), Thomas Spahni [EMAIL PROTECTED] wrote:
On Wed, 3 Nov 2004, Yves Arsenault wrote:
Thanks to all of you who replied.
Yves
On Wed, 3 Nov 2004 13:57:33 + (GMT), andy thomas [EMAIL PROTECTED] wrote:
On Wed, 3 Nov 2004, Yves Arsenault wrote:
Thanks for the reply,
Is there any information on the mysql.com website on how to store data
on 2 separate partitions?
I'm
Hi.
By using DATA DIRECTORY='directory' or INDEX DIRECTORY='directory' in CREATE TABLE
clause, you can specify where the MyISAM storage engine should put table's data and
index file[s].
See:
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
Also,you may use 'datadir' server