You could look into parted to resize partitions or copy the db to the desired directory and restart the damon with safe_mysqld --data-dir=/where/u/moved/db/to. I believe you'll also need to copy over the mysql database to the new location as well or mysql will fail to start. first, note your perms & users so you don't introduce a new problem.
justin -----Original Message----- From: Rahadul Kabir [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 11:00 AM To: MySql Mailing List Subject: mysql & /var dir Hi, I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql installed datadir turned out to be /var/lib/mysql. /var directory has it's own partition (/dev/hda3) and total space available is 194MB. As My databases are growing and I'm out of space now on the /var directory. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have > 25GB free. How can I achieve this? Or is this the right approach? Please provide some solution as details as possible, as I'm new into this stuff. Thanks so much. Rahad --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
