At 20:45 25/11/01 -0800, Bryan Chong wrote: Hi, >Hi folks, > > I need help to start my server with InnoDB. I have manually created >innodb_data_home_dir, >which is c:\mysql\ibdata. The mysql server is running on Windows ME >platform. my.cnf is
Notice that beside the c:\mysql\ibdata directory you need to create the c:\mysql\iblogs too. Before to try again the first start, delete the files created in c:\mysql\ibdata. Regards, Miguel >as follows: ># Example mysql config file. ># Copy this file to c:\my.cnf to set global options ># ># One can use all long options that the program supports. ># Run the program with --help to get a list of available options > ># This will be passed to all mysql clients >[client] >#password=my_password >port=3306 >#socket=MySQL > ># Here is entries for some specific programs ># The following values assume you have at least 32M ram > ># The MySQL server >[mysqld] >port=3306 >#socket=MySQL >skip-locking >default-character-set=latin1 >set-variable = key_buffer=16M >set-variable = max_allowed_packet=1M >set-variable = thread_stack=128K >set-variable = flush_time=1800 > ># Uncomment the following rows if you move the MySQL distribution to another ># location >basedir = c:/mysql/ >datadir = c:/mysql/data/ > ># Uncomment the following rows if you are using InnoDB tables ># Create the directories ibdata and iblogs before to start the server. ># If necessary, modify the size of the files > >innodb_data_file_path = ibdata1:200M >innodb_data_home_dir = c:\mysql\ibdata >set-variable = innodb_mirrored_log_groups=1 >innodb_log_group_home_dir = c:\mysql\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 >#.._arch_dir must be the same as .._log_group_home_dir >innodb_log_arch_dir = c:\mysql\iblogs >innodb_log_archive=0 >set-variable = innodb_buffer_pool_size=80M >set-variable = lower_case_table_names =0 >set-variable = innodb_additional_mem_pool_size=10M >set-variable = innodb_file_io_threads=4 >set-variable = innodb_lock_wait_timeout=50 > ># Uncomment the following row if you are using a Max server and you don't >want the ># InnoDb tables > >#skip-innobd > >[mysqldump] >quick >set-variable = max_allowed_packet=16M > >[mysql] >no-auto-rehash > >[isamchk] >set-variable= key=16M > >[client_fltk] >help_file= c:\mysql\sql_client\MySQL.help >client_file= c:\mysql\MySQL.options >history_length=20 >database = test >queries_root= c:\mysql\queries >last_database_file= c:\mysql\lastdb > >The error I am getting is as follows: > >C:\>c:\mysql\bin\mysqld-max --standalone >InnoDB: Warning: operating system error number 3 in a file operation. >InnoDB: Cannot continue operation. > >I appreciate your great help. Thanks > > >--------------------------------------------------------------------- >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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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
