Andrew, please do not send attachments to the mailing list. They do not come through.
I have copied parts from the InnoDB online manual, section 2, below. I hope they help in installation. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ....... When you the first time create an InnoDB database, it is best that you start the MySQL server from the command prompt. Then InnoDB will print the information about the database creation to the screen, and you see what is happening. See below in section 3 what the printout should look like. For example, in Windows you can start mysqld-max.exe with: your-path-to-mysqld>mysqld-max --standalone --console Where to put my.cnf or my.ini in Windows? The rules for Windows are the following: Only one of my.cnf or my.ini should be created. The my.cnf file should be placed in the root directory of the drive C:. The my.ini file should be placed in the WINDIR directory, e.g, C:\WINDOWS or C:\WINNT. You can use the SET command of MS-DOS to print the value of WINDIR. If your PC uses a boot loader where the C: drive is not the boot drive, then your only option is to use the my.ini file. .......... To use InnoDB tables in MySQL-Max-3.23 you MUST specify configuration parameters in the [mysqld] section of the configuration file my.cnf, or on Windows optionally in my.ini. At the minimum in 3.23 you must specify innodb_data_file_path. In MySQL-4.0 you do not need to specify even innodb_data_file_path: the default for it is to create a 64 MB file ibdata1 to the datadir of MySQL. But to get good performance you MUST explicitly set the InnoDB parameters listed below in the examples. Suppose you have a Windows NT computer 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 # Data files must be able to # hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M # Set buffer pool size to 50 - 80 % # of your computer's memory set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs # .._log_arch_dir must be the same # as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 # Set the log file size to about # 15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit to # 0 if you can afford losing # a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note that InnoDB does not create directories: you have to create them yourself. Check also that the MySQL server has the rights to create files in the directories you specify. .................. ............... Please help Hi, I have downloaded and installed mySQL, but when I enter in "c:\mysql\bin> mysqld-max --standalone" I get an error. What am I doing wrong? The error is attached as a jpg file. Many Thanks Andrew --------------------------------------------------------------------- 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
