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 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