Hi all

please go through this one and help me.

i have been trying to using mysqld --install with all options in my.ini
our requirement is with out my.ini & my.cnf,
our aim is to start mysql as an automatic service.

For this one we are using
windows 2000,
mysql 4.0.12
we are tring to building an installer with InstallAnywhere
here $USER_MAGIC_FOLDER_4$ is Mysql installation directory.

I am tring to execute this one as a service at command prompt at installation time.
$USER_MAGIC_FOLDER_4$$/$mysql$/$bin$/$mysqld --install --port=3306 --skip-external-locking --default-character-set=latin1
--key_buffer_size=16M --thread_stack=128K --flush_time=1800
--innodb_data_file_path= ibdata:200M:autoextend
-- innodb_additional_mem_pool_size=21M

I tried with --datadir=$USER_MAGIC_FOLDER_4$$/$mysql$/$data

but same errors.

3. After Installation

i) Mysql is apearing at services, but i tried to start that service then it is going to terminate with 1067 error
ii) At command prompt
a. mysql\bin>mysqld --insta
i am getting these mesages:

The service started Successfully
The Service already exists!
The current server installed : mysql\bin> mysqld --install.

b. mysql\bin>mysql
Error 2003 :Can't connect to MySql server on 'localhost' <10061>

iii) In mysql\data\

hostname.err , it is creating when i tried to start Mysql service

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
040323 14:34:11 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: all log files must be created at the same time.
InnoDB: All log files must be created also in database creation.
InnoDB: If you want bigger or smaller log files, shut down the
InnoDB: database and make sure there were no errors in shutdown.
InnoDB: Then delete the existing log files. Edit the .cnf file
InnoDB: and start the database again.
040323 14:34:11 Can't init databases
040323 14:34:11 Aborting
040323 14:34:11 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040323 14:34:11 MySql: Shutdown Complete
040323 14:34:27 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files..
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 1200423348
InnoDB: Doing recovery: scanned up to log sequence number
040323 14:34:27 MySql: Got signal 11. Aborting!

040323 14:34:27 Aborting
040323 14:34:27 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040323 14:34:27 MySql: Shutdown Complete

kindly infrom me modifcations ..in my implementation

Advance thanks