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
