Hi Dennis, There's several ways you can move the datafile location:
1. create a symlink at /var/lib/mysql that points to your data directory 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html 3. you can specify the data directory location as a configure option before compiling. Lots about this issue in the archives, too. Take a look. Hope this helps, /Rob At 09:56 -0600 2001/12/30, DWilliams wrote: >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 -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive --------------------------------------------------------------------- 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
