Julia, Tuesday, December 03, 2002, 10:50:19 PM, you wrote: >> Tuesday, December 03, 2002, 2:24:49 AM, you wrote: >> >> JS> I have just installed the mysql binary on solaris 8. >> JS> I would like have the data go to a different directory than /local/mysql/data. >> JS> How do I get it to do that? >> >> JS> I tried starting it with the --datadir set, but that didn't work. >> JS> I tried setting datadir in the /etc/my.cnf file, but that didn't work. >> JS> I tried making /local/mysql/data a softlink to a different place, but >> JS> that didn't work. >> JS> I tried making /local/mysql/data/mysql a softlink to a different place, but >> JS> that didn't work. >> >> What exactly doesn't work? Could you be more detailed?
JS> Here's more detail: JS> I shutdown and added /etc/my.cnf file: JS> kaaawa# more /etc/my.cnf JS> [mysql] JS> datadir = /db_data/mysql_data The section must be [mysqld], not [mysql] JS> hide the installed data directory: JS> kaaawa# mv data data.orig JS> started up again: JS> kaaawa# bin/safe_mysqld --user=mysql & JS> [1] 963 JS> kaaawa# The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable JS> Please do a cd to the mysql installation directory and restart JS> this script from there as follows: JS> ./bin/safe_mysqld. JS> [1] Exit 1 bin/safe_mysqld --user=mysql JS> kaaawa# JS> Next I shutdown and got rid of /etc/my.cnf JS> I made /local/mysql/mysql-3.23.51/data a link to /db_data/mysql_data JS> lrwxrwxrwx 1 root other 19 Dec 3 10:09 data -> /db_data/mysql_data JS> Try to start up: JS> kaaawa# bin/safe_mysqld --user=mysql & JS> [1] 826 JS> kaaawa# Starting mysqld daemon with databases from /local/mysql/mysql-3.23.51/data JS> 021203 10:10:40 mysqld ended JS> Try making the softlink from /local/mysql/mysql-3.23.51/data/mysql to JS> /db_data/mysql_data and that wouldn't start either: JS> lrwxrwxrwx 1 root other 25 Dec 3 10:17 mysql -> /db_data/mysql_data/mysql JS> kaaawa# bin/safe_mysqld --user=mysql & JS> [1] 896 JS> kaaawa# Starting mysqld daemon with databases from /local/mysql/mysql-3.23.51/data JS> 021203 10:17:40 mysqld ended Julia, if you can't start mysqld, look at the error log file (<host_name>.err) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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