>
Well I change the datadir in mysql-max and I have generated numerous versions of my.cnf directing MySQL to my desired directory each change causing MySQL refused to run. So I keep playing around with mysql-max and found that there is a second place where the config file does a test of the datadir so I changed that. At that point MySQL would open and did switch data directories. Continued to play with MySQL, making and deleting DB et. i.e. all the things a newbie does with a book and a new program. Then, I shut the box down for the night and went home. It is after all only a test box at this time but it is damn noise so to keep the piece down it goes. Anyway, firing it up the next afternoon I was amassed to discover that MySQL would not open with the same old error message that it could not find the data directory. I the reset the data directory to the original settings and MySQL again started working. So, there are at least 3 places that you MUST change the data directory at in configuration files in order to change the data directory. Best best is to do it by symbolic link as no newbie is going to figure out how to do it in configuration files. My only comment: "How quaint, how 1950s" that there exist programs in which one can not select the data directory.
Frank
PS. Thanks for the help. It is definitely appreciated.
Frank,
One thing to keep in mind, when changing things in the file in /etc/rc.d/init.d - You have to stop and restart MySQL before they take effect. The values in the script are only read at startup. You should probably learn about the service command. If you are using mysql, then you would run "service mysql start" to start it, "service mysql stop" to stop it, and "service mysql restart" to test your changes. If you use mysql-max, then use that in mlace of mysql in the service command.
You may also be having a problem because on not understanding how the script works. Not every instruction in the script get run. It does tests, and if a value is set, then it skips part of the code. This is why you see references to /etc/my.cnf in the script, even though creating or changing this file has no affect on MySQL. This is because that part of the script does not get accessed on a Mandrake box. So you will want to be carefull aboout changing things in the script. The values that you would want to change are always at the beginning of the line, and normaly have a comment block before them.
Mikkel --
Do not meddle in the affairs of dragons, for you are crunchy and taste good with Ketchup!
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
