got it thank everybody for the help... it is appreciated... -- On Thu, 27 Jun 2002 15:13:31 Peter Lovatt wrote: >[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 >> > >
____________________________________________________________ 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
