On Wed, Jun 18, 2008 at 1:10 PM, Sergei Golubchik <serg@stripped> wrote:
> Hi!
>
> On Jun 18, Amit k. Saha wrote:
>> Hi all,
>>
>> I have built MySQL 5.1.24-rc on Linux and have got the binaries in
>> /home/amit/work-space/mysql/mysql_install/
>>
>> Now, when I start the MySQL server daemon:
>>
>> amit@ubuntu804-laptop:~/work-space/mysql/mysql_install/libexec$ ./mysqld
>>
>> This is what I get:
>>
>>
>> 080618 12:42:03 [ERROR] Can't find messagefile
>> '/usr/share/mysql/english/errmsg.sys'
>> 080618 12:42:03 [Warning] Can't create test file
>> /var/lib/mysql/ubuntu804-laptop.lower-test
>> 080618 12:42:03 [Warning] Can't create test file
>> /var/lib/mysql/ubuntu804-laptop.lower-test
>> ./mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
>> 080618 12:42:03 [ERROR] Aborting
>>
>> I believe I will have to over-ride the default locations to point to
>> my custom installation directory.
>>
>> How do I do this?
>
> There two possibilities - you can do it at build time, run
>
> ./configure --help
>
> and see what it offers; or at run time, run
>
> ./mysqld --help --verbose
./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
--Amit
--
Amit Kumar Saha
http://blogs.sun.com/amitsaha/
http://amitksaha.blogspot.com
