Hi,

after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you
for your hints), I can't start start the DB with the start.server script.

I created a /etc/my.cnf file with the following values:

[mysqld]
innobase_data_home_dir = /opt/mysql/var/
innobase_log_group_home_dir = /opt/mysql/var
innobase_log_arch_dir = /opt/mysql/mysql/var
innobase_data_file_path = ib_data1:10M
set-variable = innobase_mirrored_log_groups=1
set-variable = innobase_log_files_in_group=3
set-variable = innobase_log_file_size=5M
set-variable = innobase_log_buffer_size=8M
innobase_flush_log_at_trx_commit=1
innobase_log_archive=0
set-variable = innobase_buffer_pool_size=16M
set-variable = innobase_additional_mem_pool_size=2M
set-variable = innobase_file_io_threads=4
set-variable = innobase_lock_wait_timeout=50
~


After starting I found the following error in the .err file:

010405 14:30:32  mysqld started
/opt/mysql/libexec/mysqld: unrecognized option `--~'
/opt/mysql/libexec/mysqld  Ver 3.23.36 for hp-hpux11.00 on hppa1.1
Copyright (C) 2000 MySQL AB & MySQL Finland AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Starts the MySQL server

Usage: /opt/mysql/libexec/mysqld [OPTIONS]

  --ansi                Use ANSI SQL s.

snip


After removing the /etc/my.cnf file the server starts sucessfully, but without
initializing the innobase stuff because the necessary pathes/variables are not
set.

Okay, second I tried, sucessfully, to start mysqld manually with the
following commandline

 /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ 
--datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \
--innobase_data_file_path=ib_data1:10M


I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options
correctly???

By the way, I need to append a '/' at the end of the innobase_data_home_dir
path in contrast to documentation. 

Greetings from Germany 

Andre


----------------------------------
E-Mail: [EMAIL PROTECTED]
Date: 05-Apr-01
Time: 14:20:03

()  Join the ASCII ribbon campaign against html email
/\  and Microsoft attachments.

"I heard if you play the NT-4.0-CD backwards, you get a satanic message"
"That is nothing, if you play it forward, it installs NT-4.0"

----------------------------------

---------------------------------------------------------------------
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

Reply via email to