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