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
