Re: Default data dir

2002-10-14 Thread Iikka Meriläinen
On Mon, 14 Oct 2002, Niranjan Patel wrote: > I get that point but is there any other way we can > change the path . Hi, You can reposition your entire data directory by using the --datadir=/path/to/new/data/dir command line parameter to mysqld. This repositions all databases, and you have to co

Re: Default data dir

2002-10-14 Thread nellA hciR
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

Re: Default data dir

2002-10-14 Thread Jeff Kilbride
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

Re: Default data dir

2002-10-14 Thread Niranjan Patel
I get that point but is there any other way we can change the path . Thanks Niranjan --- Jeff Kilbride <[EMAIL PROTECTED]> wrote: > You can relocate an entire database with a symbolic > link: > > ln -s /path/to/database/files > /var/lib/mysql/database_name > > --jeff > > - Original Message

Re: Default data dir

2002-10-14 Thread Jeff Kilbride
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 Subject: Default data dir > Hello