thanks for the valuable tips sanjay gupta
----- Original Message ----- From: "Thierno Cissé" <[EMAIL PROTECTED]> To: "'sanjay gupta'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 3:50 PM Subject: RE: how to change default data directory > Hi Sanjay, > I see two ways to proceed : > 1 - after install, move or copy (with -R option) your actual datadir > under /var/lib/mysql > (that is to say all the directories located under /var/lib/mysql/*) > to /var1/lib/mysql, > and then modify in your my.cnf the variable > <datadir=/var1/lib/mysql> to correspond with the new directory. > NOTE : stop the mysqld daemon before copying or moving directories. > > 2 - before install, configure in your my.cnf the futur directory to use > with the variable <datadir=/var1/lib/mysql>; > then place it under /etc/ - this cause the script > <scripts/mysql_install_db> to find in /etc/my.cnf the datadir to use. > After install, you'll see that the directories mysql and test are > placed under </var1/lib/mysql/> > > Hope this help > Thierno6C > > -----Original Message----- > From: sanjay gupta [mailto:[EMAIL PROTECTED] > Sent: jeudi 4 septembre 2003 09:35 > To: [EMAIL PROTECTED] > Subject: how to change default data directory > > > Hi All , > I am using RH7.1 box . I am preparing to install mysql > 4.0.13. Previously when i installed the mysql the mysql data directory > was /var/lib/mysql . I uninstall the mysql . Now i want my data > directory to be /var1/lib/mysql instead of /var/lib/mysql . I want this > because var1 is mounted to my raid device /dev/md0 and i want mysql > data directory should be /var1 > > any suggestions > > sanjay > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
