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 variable
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 partiti
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:
>
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'.
Using Symbolic Links
You
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, Yve
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,
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
(
