Marjolein,
if you do not want to use transactional InnoDB tables,
add
skip-innodb
to the [mysqld] section of your my.cnf or my.ini.
Otherwise below are examples of setting:
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 be < 4G, and < 2G on some file systems! The
combined size of data files must be >= 10 MB. InnoDB does not create
directories: you have to create them yourself.
Regards,
Heikki
http://www.innodb.com
>Configuration: multiboot system. C: is for DOS and System Commander, R: is
for Win2K. \
>(Most) applications go on F:, (most) data goes on P:.
>- I installed MySQL to F:\Development\Database\MySQL
>- I edited my-example.cnf and added [mysqld]
>basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/
>then Save as to C:\my.cnf (do I *really* have to store this on a drive that's \
>reserved for DOS and multiboot?) The installation created databases 'mysql'
and \
>'test' on F: - I copied these to the designated data location on P:.
>- I ran winmysqladmin.exe, created an .ini file and designated
mysqld-nt.exe as the \
>service, then tried to start it. The traffic light remains red. (The ini
file is in \
>the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which
wants to \
>connect to localhost - but can't connect. - In the Services applet,
mysqld-nt.exe is \
>registered as a service, automatic, but not started. - After reboot, same
situation: \
>the service is automatic, but not started. Trying to start results in an
error. - \
>Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt
--remove - Tried \
>to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld
--debug \
>--standalone this results in an error: "Can't initialize InnoDB as \
>'innodb_data_file_path' is not set" and mysqld hung - I had to kill it from
task \
>manager. - Tried to start mysqld (no debug) with \
>F:\Development\Database\MySQL\bin\mysqld --standalone this results in the
error - I \
>had to kill it from task manager again. (Note: while mysqld hangs, \
>winmysqladmin.exe's traffic light in the system tray is green, so it does
detect if \
>mysqld is running.)Now what?Thanks,Marjolein Katsma
>HomeSite Help - http://hshelp.com/
>Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html
---------------------------------------------------------------------
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
