On Wed, Jun 18, 2008 at 1:45 PM, Sergei Golubchik <serg@stripped> wrote:
> Hi!
>
> On Jun 18, Amit k. Saha wrote:
>> On Wed, Jun 18, 2008 at 1:10 PM, Sergei Golubchik <serg@stripped> wrote:
>> > On Jun 18, Amit k. Saha wrote:
>>
>> ./mysqld --print-defaults gives me:
>>
>>
>> ./mysqld would have been started with the following arguments:
>> --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
>> --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr
>> --datadir=/var/lib/mysql --tmpdir=/tmp
>> --language=/usr/share/mysql/english --skip-external-locking
>> --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M
>> --thread_stack=128K --thread_cache_size=8 --query_cache_limit=1M
>> --query_cache_size=16M --expire_logs_days=10 --max_binlog_size=100M
>> --skip-bdb --basedir=/home/amit/work-space/mysql/mysql_install
>>
>> What bothers me is the double occurrence of '--basedir'- with a
>> correct location in the latter case.
>>
>> My configure switch was:
>>
>> ./configure --with-debug --prefix=/home/amit/work-space/mysql/mysql_install
>>
>> But, ./mysqld --no-defaults does the trick:
>>
>> 080618 13:29:16 [Note] Event Scheduler: Loaded 0 events
>> 080618 13:29:16 [Note] ./mysqld: ready for connections.
>> Version: '5.1.24-rc-debug' socket: '/tmp/mysql.sock' port: 3306
>> Source distribution
>
> Without --no-defaults it's picking up the global /etc/my.cnf, apparently.
Ah, yes- there was an older my.cnf file lying there. Removed it and
works great, without the --no-defaults
Great.
Amit
--
Amit Kumar Saha
http://blogs.sun.com/amitsaha/
http://amitksaha.blogspot.com