Hi,
I'm installed the amp package on b134 and got it working, now I'm trying to
move the mysql data directory to my data drive. I added the line "datadir =
/tank/server/mysql/data" to my.cnf file but it doesn't work. So to debug I
tried:
# ps -fu mysql
UID PID PPID C STIME TTY TIME CMD
mysql 1159 1 0 00:13:54 ? 0:00 /bin/sh
/usr/mysql/5.1/bin/mysqld_safe --user=mysql --datadir=/var/mysql/5.1/da
mysql 1291 1159 0 00:13:54 ? 0:00 /usr/mysql/5.1/bin/mysqld
--basedir=/usr/mysql/5.1 --datadir=/var/mysql/5.1/dat
which shows that the mysqld file is in /usr/mysql/5.1/bin and the data
directory is still the default. So then I went to that directory and did:
#./mysqld --print-defaults
--port=3306 --socket=/tmp/mysql.sock --skip-locking --key_buffer_size=16K
--max_allowed_packet=1M --table_open_cache=4 --sort_buffer_size=64K
--read_buffer_size=256K --read_rnd_buffer_size=256K --net_buffer_length=2K
--thread_stack=128K --datadir=/tank/server/mysql/data --server-id=1 --port=3306
--socket=/tmp/mysql.sock --skip-locking --key_buffer_size=16K
--max_allowed_packet=1M --table_open_cache=4 --sort_buffer_size=64K
--read_buffer_size=256K --read_rnd_buffer_size=256K --net_buffer_length=2K
--thread_stack=128K --datadir=/tank/server/mysql/data --server-id=1
which shows that I got the correct datadir parameter in the my.cnf.
Lastly ./mysqladmin shows:
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /etc/mysql/5.1/my.cnf ~/.my.cnf
I saw here:
http://blogs.sun.com/rainy/entry/why_isn_t_mysql_using
that you can specify the config file when running the binary but I'm not sure
how to do that in the correct manner while still using "svcadm enable mysql".
Any help would be great.
Thanks.
--
This message posted from opensolaris.org
_______________________________________________
databases-discuss mailing list
[email protected]
http://mail.opensolaris.org/mailman/listinfo/databases-discuss
