#This File was made using the WinMySQLAdmin 1.4 Tool
#2002/10/30 下午 04:00:26    #Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions    [mysqld]
basedir=C:/mysql
#bind-address=192.15.1.217
datadir=E:/mysdata
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
# You can write your other MySQL server options here
# ...
innodb_data_home_dir =
# Data files must be able to
# hold your data and indexes
innodb_data_file_path = E:/MysData/ibdata/ibdata1:10M:autoextend
# Set buffer pool size to
# 50 - 80 % of your computer's
# memory, but make sure on Linux
# x86 total memory usage is
# < 2 GB
set-variable = innodb_buffer_pool_size=1G
set-variable = innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = E:/MysData/iblogs
# .._log_arch_dir must be the same
# as .._log_group_home_dir
innodb_log_arch_dir = E:/MysData/iblogs
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=150M
set-variable = innodb_log_buffer_size=8M
# Set ..flush_log_at_trx_commit to
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=Administrator
password=mick

引言: 我的 my.ini 內容如下 紅色部分是我加上去的，不過問題仍在 不知哪裡還要修正 ? innodb_data_home_dir = # Data files must be able to # hold your data and indexes innodb_data_file_path =c:/APACHE/mysql/data:10M:autoextend # Set buffer pool size to # 50 - 80 % of your computer's # memory, but make sure on Linux # x86 total memory usage is # < 2 GB set-variable = innodb_buffer_pool_size=1G set-variable = innodb_additional_mem_pool_size=20M innodb_log_group_home_dir =c:/APACHE/mysql/data/iblogs # .._log_arch_dir must be the same # as .._log_group_home_dir innodb_log_arch_dir = c:/APACHE/mysql/data/iblogs 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=150M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit to

1. c:/APACHE/mysql/data
   c:/APACHE/mysql/data/iblogs
必須先 create 好.
2. MySQL Manual for reference:
http://delphi.ktop.com.tw/topic.php?TOPIC_ID=26786

引言: 感謝 Mr. Mickey 您上傳的 MySQL Manual referance 好像沒傳成功喔 也在此感謝 Mr. bookworm 我會去官方網站看看 ●○○○○○●○○○○○● 竹密不妨水過，山高無礙雲飛

Testing from a DOS command prompt is the best thing to do because the server displays
status messages that appear in the DOS window. If something is wrong with your congu-
ration, these messages will make it easier for you to identify and x any problems.
Make sure you are in the directory where the server is located, then enter this command:
C:\mysql\bin> mysqld-max --standalone
You should see the following messages as the server starts up:
InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist:
InnoDB: a new database to be created!
InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 31457280
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: creating foreign key constraint system tables
InnoDB: foreign key constraint system tables created
011024 10:58:25 InnoDB: Started