Thanks a lot for your help Christian.
I tried running the server from the DOS prompt and it complained about the
innodb_log_arch_dir variable. It is running fine now.
Rashmi
-----Original Message-----
From: Christian Jaeger [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 11:32 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>The directories specified in the above variables exist.
>However when I try to run the service I get the error "Could not start the
>MySQL service on Local Computer... Error 1067: The process terminated
>unexpectedly". No error is logged in the mysql.err file in the data
>directory.
It seems you are missing a innodb_log_arch_dir directive. I remember
innodb complaining about this not having the same value as
innodb_log_group_home_dir. Anyway, you could probably try to start
the daemon from the dos prompt directly, so you see error messages -
at least that's what I do on linux. (Currently I start it through a
perl script with the following options (strip the unix_file_flush
stuff of course):
exec qw{
/usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var
--pid-file=/usr/local/mysql/var/pflanze.pid
--skip-locking
--innodb_data_home_dir=/usr/local/mysql/
--innodb_data_file_path=ibdata/ibdata1:1000M
--set-variable=innodb_mirrored_log_groups=1
--innodb_log_group_home_dir=/usr/local/mysql/iblog/
--set-variable=innodb_log_files_in_group=3
--set-variable=innodb_log_file_size=50M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=1
--innodb_log_arch_dir=/usr/local/mysql/iblog/
--innodb_log_archive=0
--set-variable=innodb_buffer_pool_size=90M
--set-variable=innodb_additional_mem_pool_size=5M
--set-variable=innodb_file_io_threads=4
--set-variable=innodb_lock_wait_timeout=50
--innodb_unix_file_flush_method=O_DSYNC
};
)
christian.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
