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
