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
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,
