I did, see below from my prev email, that part works fine: innodb_data_home_dir=c:/mysql innodb_data_file_path=ibdata1 like I said, the system created a 10mb file called ibdata1 in c:\mysql But to recap, when I try to add the specifications for logs, it wort start, that's the next line: innodb_log_group_home_dir = c:\iblogs Pete Heikki Tuuri wrote: > > Hi! > > You have to specify also the data file size in innodb_data_file_path. The > following example is > from the manual at www.innodb.com: > > Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB > hard disk. Below is an example of possible configuration parameters in > `my.cnf' for InnoDB: > > [mysqld] > # You can write your other MySQL server options here > # ... > # > innodb_data_home_dir = c:\ibdata > innodb_data_file_path = ibdata1:2000M;ibdata2:2000M > 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 think it is easiest that you copy and paste the above to your my.cnf > and adjust directories, file sizes, and pool sizes to your needs. Files must > be > < 4 GB currently. > > Hope it now succeeds! > > Heikki > > -----Original Message----- > From: Pete Kuczynski <[EMAIL PROTECTED]> > To: Heikki Tuuri <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Wednesday, July 18, 2001 10:14 PM > Subject: Re: innodb on nt4 > > Ok, got the following line working in my.ini, it created a 10mb ibdata > file: > innodb_data_home_dir=c:/mysql > innodb_data_file_path=ibdata1 > set-variable=innodb_mirrored_log_groups=1 > > but, when I add innodb_log_group_home_dir=c:/iblogs > > mysyl won't start. I created a iblogs directory. > > Any ideas? > > Pete > > Heikki Tuuri wrote: > > > > Pete, > > > > no, below you have a path: > > > > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata > > > > ibdata is a directory name, not a file name. InnoDB will add the > > extra backslash after it. But InnoDB does not create directories. > > You must manually create the directories you use. > > > > Regards, > > > > Heikki > > http://www.innodb.com > > > > Copied message: > > ......................... > > Hi, > > > > have a question about the inno_data_home_dir line on mysql-max3.23 > > do I create a file called "ibdata" cause it's not in any directory by > > default by default. > > > > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata > > > > Pete > > > > Crercio Osmaildo da Silva wrote: > > > > > > Hi, > > > > > > For windows systems, you can install mysql-max-3.23.39, that has support > > for > > > both BDB and InnoDB. For InnoDB you need to change my.cnf and include > > these > > > lines:> > # For Innodb Databases > > > # change D:\WebApp\mysql\innodb and the other parameters to fit your> # > > needs > > > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata > > > innodb_data_file_path = ibdata1:20M;ibdata2:20M > > > set-variable = innodb_mirrored_log_groups=1 > > > innodb_log_group_home_dir = D:\webapp\mysql\innodb\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 = D:\webapp\mysql\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> > > > Then you use mysql\bin\mysqld-max-nt --install to install it as a > service. > > > You can run SHOW VARIABLES to see the which table types are available.> > > > That's it.> > > > If you need more help, just email-me. I'd be glad to help you out.> > > > []'s> > > > Crercio O. Silva> > -----Original Message----- > > > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] > > > Sent: terça-feira, 17 de julho de 2001 11:20> To: [EMAIL PROTECTED] > > > Subject: innodb on nt4> > > > Ok, tried to update existing table(s) to InnoDB [from MYISAM] using > > > "alter table da_table type=InnoDB;, but show variables still shows > > > table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it > > > installs with MYISAM only, not InnoDB options.> > > > I cannot find any documentation on instaling mysql on NT with InnoDB > > > "compiled" in. Is there such a thing? Where? > > > Bottom line, how do I get InnoDB "compiled" in with a standard mysql > > > database installation. All I want out of this is transaction support.> > > > Best Rgards!> > Pete> > _______________________________________ > > > Pete Kuczynski> Sr. Field Engineer> DHL Airways Inc. > > > Infrastructure Technology & Services> (773)-462-9758 > > > 24/7 Helpdesk 1-800-434-5767> > > > --------------------------------------------------------------------- > > > 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-- > > _______________________________________Pete KuczynskiSr. Field Engineer > > DHL Airways Inc.Infrastructure Technology & Services(773)-462-9758 > > 24/7 Helpdesk 1-800-434-5767 > > --------------------------------------------------------------------- > > 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]> > > > > --------------------------------------------------------------------- > > 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 > > -- > _______________________________________ > Pete Kuczynski > Sr. Field Engineer > DHL Airways Inc. > Infrastructure Technology & Services > (773)-462-9758 > 24/7 Helpdesk 1-800-434-5767 -- _______________________________________ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767
--------------------------------------------------------------------- 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
