What is the purpose of creating the symlink if I manually edit the data directory variable? Would it be better to:
a) Move the data, and edit the data directory to the new location b) Move the data, and create a symlink to the new data TIA, --- Rahadul Kabir <[EMAIL PROTECTED]> wrote: > > > Daren Cotter wrote: > > > My Linux installation only has about 1gb in the > /var > > partition, so I need to relocate my databases to > the > > /home partition. I'm pretty sure the following > > commands will shutdown mysql, move the data > directory, > > create a symbolic link, and then restart mysql. > > I think you should also change the datadir value in > /etc/rc.d/init.d/mysql > /usr/bin/safe_mysqld > > set the datadir=/home/mysql or something > > > My > > question is, is this complete, or do I need to > > chown/chgrp/chmod the new symbolic link directory? > > > > nope > > > > > mysqladmin -u root -p shudown > > mv /var/lib/mysql /home > > ln -s /home/mysql /var/lib/mysql > > /etc/rc.d/init.d/mysqld start > > > > Query, SQL > > > > __________________________________________________ > > Do You Yahoo!? > > HotJobs - Search Thousands of New Jobs > > http://www.hotjobs.com > > > > > --------------------------------------------------------------------- > > 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 > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- 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