to tomiw: 如果果如你所言,建议重新安装MySQL4.1.12a,弄个noinstall的吧,解压就可以用的那种。 这段时间以来,我一直用mysql4.1.10的,挺好的,berkley和innodb引擎都支持。
不是这个意思, 配置default-table-type = innodb是指在配置了服务器支持InnoDB的情况下, 用Create table建立的表,都会是InnoDB格式的, 如果你没有在服务器上配置InnoDB支持的话,是不行的, 我的my.ini配置如下: # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options# This will be passed to all mysql clients [client] #password=my_password port=3308 #socket=MySQLdefault_character_set = gbk# Here is entries for some specific programs # The following values assume you have at least 32M ram# The MySQL server [mysqld] port=3308 #socket=MySQLcharacter_set_server = gbkskip-locking #lower_case_table_names=2 set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 1# Uncomment the following if you want to log updates #log-bin# Uncomment the following rows if you move the MySQL distribution to another # location basedir = D:/NSPlatform/MySQL4.1/ datadir = D:/NSPlatform/MySQL4.1/Data/ # Uncomment the following if you are NOT using BDB tables #skip-bdb # 看上面英文的意思,这个部分是配置InnoDB数据引擎的# Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=10000# Uncomment the following if you are using Innobase tables innodb_data_file_path = IBDataMain:24M:autoextend innodb_data_home_dir = D:/NSPlatform/MySQL4.1/IBData innodb_log_group_home_dir = D:/NSPlatform/MySQL4.1/IBLogs innodb_log_arch_dir = D:/NSPlatform/MySQL4.1/IBLogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=8M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # InnoDB的配置到此为止[mysqldump] quick set-variable = max_allowed_packet=16M[mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates[isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M[myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M[mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=D:/NSPlatform/MySQL4.1/bin/mysqld-nt.exe
create table(id int not null, name varchar(32)) ENGINE=InnoDB;
就可以创建innodb引擎的表
iihero(阿黑哥) :我是那样写的,可是不行
如果果如你所言,建议重新安装MySQL4.1.12a,弄个noinstall的吧,解压就可以用的那种。
这段时间以来,我一直用mysql4.1.10的,挺好的,berkley和innodb引擎都支持。
配置default-table-type = innodb是指在配置了服务器支持InnoDB的情况下,
用Create table建立的表,都会是InnoDB格式的,
如果你没有在服务器上配置InnoDB支持的话,是不行的,
我的my.ini配置如下:
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options# This will be passed to all mysql clients
[client]
#password=my_password
port=3308
#socket=MySQLdefault_character_set = gbk# Here is entries for some specific programs
# The following values assume you have at least 32M ram# The MySQL server
[mysqld]
port=3308
#socket=MySQLcharacter_set_server = gbkskip-locking
#lower_case_table_names=2
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1# Uncomment the following if you want to log updates
#log-bin# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = D:/NSPlatform/MySQL4.1/
datadir = D:/NSPlatform/MySQL4.1/Data/
# Uncomment the following if you are NOT using BDB tables
#skip-bdb
# 看上面英文的意思,这个部分是配置InnoDB数据引擎的# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000# Uncomment the following if you are using Innobase tables
innodb_data_file_path = IBDataMain:24M:autoextend
innodb_data_home_dir = D:/NSPlatform/MySQL4.1/IBData
innodb_log_group_home_dir = D:/NSPlatform/MySQL4.1/IBLogs
innodb_log_arch_dir = D:/NSPlatform/MySQL4.1/IBLogs
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=8M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
# InnoDB的配置到此为止[mysqldump]
quick
set-variable = max_allowed_packet=16M[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M[mysqlhotcopy]
interactive-timeout
[WinMySQLAdmin]
Server=D:/NSPlatform/MySQL4.1/bin/mysqld-nt.exe