t; > link:
> >
> > ln -s /path/to/database/files
> > /var/lib/mysql/database_name
> >
> > --jeff
> >
> > - Original Message -
> > From: "Niranjan Patel" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Se
i have this as part of /etc/my.cnf, all data file are in the directory
/my. be sure to set your permissions on /my to the mysql user
[mysqld]
datadir=/my
- hcir
On Monday, Oct 14, 2002, at 10:19 America/Anchorage, Niranjan Patel
wrote:
> I get that point but is there any other way we can
> c
Not on a per database basis, that I know of.
Anybody else?
--jeff
- Original Message -
From: "Niranjan Patel" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 11:19 AM
Subject: Re: Def
--jeff
>
> - Original Message -
> From: "Niranjan Patel" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, October 14, 2002 10:50 AM
> Subject: Default data dir
>
>
> > Hello
> >
> > In my case Default data file
You can relocate an entire database with a symbolic link:
ln -s /path/to/database/files /var/lib/mysql/database_name
--jeff
- Original Message -
From: "Niranjan Patel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 10:50 AM
Sub
Hello
In my case Default data files directory is
/var/lib/mysql. I want to store all files of one
database in another directory.
Is there a way we can specify data directory per
database. Or else can we change the entire data
directoy of mysql.
I tried to change it using my.cnf but I guess i mis
