Robert, Thanks for the tips...
>>1. create a symlink at /var/lib/mysql that points to your data directory<< I had read that this might not be the best way prior to v4.0, something about an "alter table" statement might ignore the symlink? >>2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see:<< I apparently don't have a 'my.cnf' file after install...I found the following in /usr/share/mysql/: my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf I guess these are example my.cnf files to use...If so, the next question which is the appropriate/best type? I guess whatever choice should be renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming the server on start-up reads this file and overrides compiled commands. Which section does the 'datadir=path/to/data/' command go...to the [mysqld] section? There is no mention of this command on: http://www.mysql.com/doc/O/p/Option_files.html >>3. you can specify the data directory location as a configure option before compiling.<< Eventually, I will learn how to do this...but I opted for the RPM instead. I guess that is why I have these sort of configuration difficulties. Thanks again, Dennis Williams ----- Original Message ----- From: "Robert Alexander" <[EMAIL PROTECTED]> To: "DWilliams" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 11:51 AM Subject: Re: MySQL RPM Install Problem - Ignorance > 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 > --------------------------------------------------------------------- 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
