Henry,
if you do not want to use transactional InnoDB tables,
add
skip-innodb
to your my.cnf or my.ini file.
If you want to use InnoDB tables, follow the instructions:
To use InnoDB tables you must specify configuration parameters in the MySQL
configuration file in the [mysqld] section of the configuration file
`my.cnf'. 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' or 'my.ini' 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
Note that data files must always be < 4G, and < 2G on some file systems!
InnoDB does not create directories: you have to create them yourself.
Regards,
Heikki
http://www.innodb.com
Copied message:
.....................
Hello,
I am new to mysql. I install windows version MySQL. I want to initial =
mysql with command mysqld, I get an error message as "can't initialize =
innoDB as 'innodb_data_file_path' is not set". Could you please help me =
how to solve this problem?
Thanks
Henry
---------------------------------------------------------------------
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
