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 copy the directory structure under the current data directory into the new directory (permission tables, for example). Best regards, Iikka > > 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 ----- > > 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 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 > > missed > > > something. can someone point me to exact steps > > > > > > Thanks > > > Niranjan > > > > > > > > > __________________________________________________ > > > Do you Yahoo!? > > > Faith Hill - Exclusive Performances, Videos & More > > > http://faith.yahoo.com > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list > > archive) > > > > > > To request this thread, e-mail > > <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > > archive) > > > > To request this thread, e-mail > > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > __________________________________________________ > Do you Yahoo!? > Faith Hill - Exclusive Performances, Videos & More > http://faith.yahoo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
