Riccardi, your innodb_log_arch_dir is
C:\InnoDB\iblogs but innodb_log_group_home_dir is C:\iblogs These should be the same. Your MySQL error log should contain an error message of this: C:\trybuild\client_debug>mysqld --console InnoDB: Error: you must set the log group home dir in my.cnf the InnoDB: same as log arch dir. 011005 16:00:07 Can't init databases Note that you must create the directories yourself: InnoDB does not create directories. When you install MySQL -Max, maybe it is best to start it the first time from the MS-DOS prompt like you see above. Then you see what it is doing. When you start as a service, there is less touch to the whole process. Regards, Heikki http://www.innodb.com >-----Messaggio originale----- >Hi All, >I want to install Mysql and InnoDb on a W2K machine. >I configure mi.ini file as it follows: > >[WinMySQLAdmin] >Server=C:/mysql/bin/mysqld.exe > >[mysqld] >port=3306 >socket=/tmp/mysql.sock >set-variable = key_buffer_size=16M >set-variable = max_allowed_packet=1M >innodb_data_file_path = ibdata1:2000M;ibdata2:2000M >innodb_data_home_dir = c:\InnoDB\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:\InnoDB\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 > >but when i try to start mysql service (net start mysql) he return me an >error: >System error N°1067 > >Where' s the error? >----------------------------------------------------- >- Moreno Riccardi >-------------------------------------- > > >--------------------------------------------------------------------------- ----- > --------------------------------------------------------------------- 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
