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]
