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. My question is, is this complete, or do I need to chown/chgrp/chmod the new symbolic link directory?
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