First try:
mysqld-max-nt -remove When its the first time running use: mysqld-max-nt --standalone -So you can see what is happening... Shutdown Then: mysqld-max-nt -install Restart as a service. I just went through this last night... Butch Bean -----Original Message----- From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 12:07 PM To: '[EMAIL PROTECTED]' Subject: Creating InnoDB tables Hello everyone, I really need your help. I have been stuck for couple of days on trying to setup MySQL server such, that it supports InnoDB tables. First of all I copy the following into my.ini after [mysqld] innodb_data_file_path = ibdata1:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I manually create iblogs and ibdata folders. I save the .ini file. Then I try to install mysqld-max-nt service by Typing c:\program files\mysql\bin\mysqld-max-nt --install It fails to install the service. In addition if I shut down my server, and fire it up again it won't start. As soon As I get rid of the new parameters except the innodb data file path, it starts working again. Does anyone knows what is going on. I'm using mysql 3.23.39 on Win2000. All I want is to be able to make it so that I can work with InnoDB as oppose to MYISAM as default. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
