Right now, my MySQL databases are inside /var/lib/mysql. I need to move them into /home, because there is not enough room in the /var partition for the databases to grow much more. This is a production server. How can I safely move the MySQL databases into /home, with minimal downtime and no data corruption? I'm guessing that I should: 1. Change mysqld configuration file to use /home/mysql instead 2. /etc/rc.d/init.d/mysql stop # stop mysqld 3. Keep checking ps -A | grep mysql until mysqld is stopped 4. mv /var/lib/mysql /home/mysql 5. /etc/rc.d/init.d/mysql start # start mysqld Is this correct? And how would I do step #1? Thanks, -Philip Mak ([EMAIL PROTECTED]) --------------------------------------------------------------------- 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
