Aha! that's what I need to know, thanks a bunch. 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]> -- _______________________________________ 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