Dennis if you want to see if the /var/lib/mysql directory is on it's own partition or drive look at /etc/fstab and see which /dev it is mounted on. If you wanted to you can mount a new drive at /var/lib/mysql and have you data on it's own drive. If you have some sort of system failure you can just mount the drive on a new installation using the /etc/fstab file.
Some people mount there individual databases on standalone drives. Not saying this the best way but it is one way if you can afford hardware. That leaves you root drives for programs. Regards Trevor -----Original Message----- From: DWilliams [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 2:56 AM To: [EMAIL PROTECTED] Subject: MySQL RPM Install Problem - Ignorance Hi all, I have recently installed a MySQL server and client RPM 3.23.47 on a Linux system. The system that I am setting up is a Cobalt RAQ4, first time for me to install MySQL on Linux. The installed datadir turned out to be /var/lib/mysql. I get errors when trying to move a very large MySQL data (800MB) directory from a previous host system. It turns out that the /var directory has it's own partition, I think. A 'df' command shows not enough room on the /var directory for the MySQL data files. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have > 15GB free. How can I achieve this? Or is this the right approach? I think I understood that the server can be started up with a different --datadir option, but I would like this to be more permanent in case of system reboots. Thanks, Dennis Williams --------------------------------------------------------------------- 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