[mysqld] datadir=/var/lib/mysql tmpdir=/home/mysql_temp HTH
Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: va ku [mailto:[EMAIL PROTECTED]] > Sent: 27 June 2002 14:19 > To: [EMAIL PROTECTED]; Peter Lovatt > Subject: RE: How to change default mysql data-dir in Linux server ? > > > Peter, > > Thanks for the reply... Infact my.cnf wasn't there when I > installed. So I created it... Could you pass me the line to > include in my.cnf for changing directory... Unfortunately I > couldn't find anything in the web site regarding this... > > > Once again thanks for the reply... > > > -- > > On Thu, 27 Jun 2002 00:26:06 > Peter Lovatt wrote: > >Search for 'my.cnf' on mysql.com > > > >This is the config file that you can use to set the data dr > > > >You may need to create it if it doesn't already exist. > > > >HTH > > > >Peter > > > >----------------------------------------------- > >Excellence in internet and open source software > >----------------------------------------------- > >Sunmaia > >www.sunmaia.net > >[EMAIL PROTECTED] > >tel. 0121-242-1473 > >----------------------------------------------- > > > >> -----Original Message----- > >> From: va ku [mailto:[EMAIL PROTECTED]] > >> Sent: 26 June 2002 20:26 > >> To: [EMAIL PROTECTED] > >> Subject: How to change default mysql data-dir in Linux server ? > >> > >> > >> > >> Hi, > >> > >> I have installed MySQL 4.0 on Linux box using RPM. Everything is > >> working fine, but the database directory is set to > >> > >> /var/lib/mysql. So everytime I create a database it is > getting created on > >> /var/lib/mysql. What I would like to have is to create database under > >> /var/lib/mysql/data_dir, where as 'data-dir' stands for database > >> directory. I beliebe I have to change configuration file. How can > >> I do that... where can I find such configuration file for a > >> typical installation. > >> > >> Any help is appreciated... > >> > >> Regards > >> > >> > >> > >> ____________________________________________________________ > >> Win a first-class trip to New Orleans and vacation Elvis Style!. > >> Enter NOW! > >> http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ > >> > >> --------- End Forwarded Message --------- > >> > >> > >> > >> ____________________________________________________________ > >> Win a first-class trip to New Orleans and vacation Elvis Style!. > >> Enter NOW! > >> http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ > >> > >> --------------------------------------------------------------------- > >> 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 > >> > > > > > > > ____________________________________________________________ > Win a first-class trip to New Orleans and vacation Elvis Style!. > Enter NOW! > http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ > > --------------------------------------------------------------------- > 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
