On Monday 21 March 2005 22:31, SOTL wrote: > On Tuesday 15 March 2005 11:21, Derek Jennings wrote: > > On Tuesday 15 March 2005 14:42, SOTL wrote: > > > Hi All > > > > > > I have created a partition on one of my computer to store critical > > > system data files called /System_Data. > > > > > > > > > I am trying to configure MySQL so that it will use /System_Data as > > > its default file storage. > > > > > > I looked for /etc/my.cnf; found I did not have one so I generated one. > > > > > > My /etc/my.cnf files contains exactly 1 line which is: > > > datadir=/System_Data > > > > > > When I start MySQL I now receive the following error message: > > > > > > Found option without preceding group in config file /etc/my.cnf at line > > > 1. Fatail error in default handling. > > > Program aborted. > > > > > > Would appreciate help in ascertaining what should be added or how > > > current should be modified. > > > > > > Frank > > > > It is failing because having created a /etc/my.cnf file it is expecting > > to find other parameters defined in there in addition to datadir > > (pid_file=, basedir=/, bindir=/usr/bin ) > > > > You could alternatively edit the datadir path in /etc/rc5.d/S90mysql > > which is the script that starts mysql > > > > Alternatively if you create a symlink from /var/lib/mysql > > to /mnt/System_Data/mysql then you would not need to change any > > configuration and your data would go in the folder you desire. > > > > BTW: In Linux /var is the default directory to hold data so why do you > > need to define a different one? > > > > derek > > Hi All and thanks Derek > > I have finally gotten back to the above issue in my attempts to resolve my > setup issues. > > I have printed the instructions for Using Option Files as kindly pointed > out to me by David G Stevenson located at: > > http://dev.mysql.com/doc/mysql/en/option-files.html > > If I understand Derek correctly my.cnf should look something like > > [mysql] > datadir=/System_Data > basedir=/ > bindir=/usr/bin > pid_file= > > This raises two issues to me. > > First what is a 'pid_file=' ? > And where is it located? > > Second I do not find pid_file, basedir, or bindir mentioned in the MySQL > Reference Manual:: 4.3.2 Using Option Files. > > Thus to say the least I am confused. > > if someone would mind enlighten me on correct procedure I would appreciate > it. > > Thank > Frank
The packager who built the Mandrake package for MySQL has created the file /etc/rc5.d/S90mysql to set up the defaults for MySQL so that a my.cnf file is unnecessary. I simply read that file and told you what the defaults were set to. I also told you that by using a symlink to /var/lib/mysql you could put your user data in a different folder without having to edit any files or create a my.cnf file. BTW: A pid file is a file usually kept in /var/run which identifies the Process Identifier number (pid) a daemon is using derek -- www.jennings.homelinux.net http://twiki.mdklinuxfaq.org
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
