Forwarded message: >Return-Path: <[EMAIL PROTECTED]> >From: "Mehalick, Richard RE SITI-ITPSCA" <[EMAIL PROTECTED]> >To: 'Heikki Tuuri' <[EMAIL PROTECTED]> >Subject: RE: Innodb Win2000 error >Date: Tue, 18 Dec 2001 11:41:45 -0600 > >Thank you for responding. I was just going to post again that I solved the >problem. It appears that the my.cnf file was named wrong :( > >I guess Notepad put a hidden extension on the file. > >Sorry for the trouble. > >Rick > >-----Original Message----- >From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, December 18, 2001 11:35 AM >To: Mehalick, Richard RE SITI-ITPSCA >Subject: Re: Innodb Win2000 error > > >Hi! > >From the MySQL online manual I read: >... >There are two configuration files with the same function: `my.cnf' and >`my.ini' file, however please note that only of one these should can used. >Both files are plain text. The `my.cnf' file should be created in the root >directory of drive C and the `my.ini' file on the WinDir directory e.g: >`C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive >isn't the boot drive, then your only option is to use the `my.ini' file. >Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is >used. The `\mysql\bin' directory contains a help file with instructions for >using this tool. >... > >If the C: drive is you boot drive, but mysqld does not find C:\my.cnf then >there is a bug in the current Windows version of MySQL, and I will submit a >bug report to Miguel from MySQL AB. > >Please send me your my.cnf! > >You could try using my.ini instead. > >Error 123 in Windows means that the syntax of a file path is wrong. MySQL >seems to put '.' as innodb_data_home_dir if it is not specified. > >You could try just > >mysqld --innodb_data_file_path=ibdata1:20M > >but to get your installation really working you have to be able to use >my.ini or my.cnf > >Regards, > >Heikki > >At 09:26 AM 12/18/01 -0600, you wrote: >>I am trying to use mysql-max-3.23.46a for Windows (Win2000) with innodb in >>use. >> >>After installing from the setup program, I copied "my-example" to >c:\my.cnf" >>and uncommented the innodb lines with the following: >> >>innodb_data_file_path = ibdata1:20M >>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=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 >> >>When I start the server standalone I get the following: >> >>C:\mysql\bin>mysqld-max-nt.exe --standalone >>Cannot initialize InnoDB as 'innodb_data_file_path' is not set. >>If you do not want to use transactional InnoDB tables, add a line >>skip-innodb >>to the [mysqld] section of init parameters in your my.cnf >>or my.ini. If you want to use InnoDB tables, add for example, >>innodb_data_file_path = /mysql/data/ibdata1:20M >>But to get good performance you should adjust for your hardware >>the InnoDB startup options listed in section 7.6 at >>http://www.mysql.com/doc/ >> >>I did a search and no other my.cnf files (or my.ini) files are on my disks, >>so I tried to start the server with the innodb options on the command line >>and got the following error: >> >>C:\mysql\bin>mysqld-max-nt.exe --standalone >>--innodb_data_file_path=c:\ibdata\ibdata1:20M >>InnoDB: Warning: operating system error number 123 in a file operation. >>InnoDB: Cannot continue operation. >> >> >>Any help would be appreciated. >> >> >>Rick Mehalick >>Sr. Consultant >>Shell Information Technology International >> >> > >
--------------------------------------------------------------------- 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