| have_innodb | DISABLED |你还是未能启动 InnoDB 表引擎 你的MySQL服务器版本??# Uncomment the following if you are using Innobase tables #skip-innodb #上一句一定要用#号注释了 innodb_data_home_dir = e:\mysql\ibdata #该目录一定要事先建好 innodb_data_file_path = ibdata1:1000M # 数据文件必须能容下数据和索引
我的mysql版本:3.23.55 是在http://www.mysql.com/downloads/mysql-3.23.html中download的描述如下: Windows downloads The Windows download contains both the Standard and Max server binaries. It also contains a version of the command-line client which uses the Cygwin library to provide command history and editing. Source code for the version of Cygwin we have used is available on this page.Windows 95/98/NT/2000/XP 3.23.55 13.3M Download | Pick a mirror MD5: 95a9add0f228d0b60ce4ea28e7e02d9b 应该是包括了max是不是只能在2000下才能启动innodb? win98下不行?我的my,ini:里面所提及的目录我都手工创建了。[WinMySQLAdmin] Server=E:/MYSQL/bin/mysqld-opt.exe user=test password=test[mysqld] basedir=E:/MYSQL #bind-address=10.21.106.198 datadir=E:/MYSQL/data #language=E:/MYSQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M#default-character-set=gb2312 log-bin = e:/mysql/log/123.log # 二进制Log文件,用于镜像服务器 log =e:/mysql/log/sql.log # Log记录 local-infile =1 # 允许使用 LOAD DATA LOCAL #socket =MySQL skip-lockingset-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_concurrency=2 # CPU数目*2 set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 1# Un comment the following if you are NOT using BDB tables skip-bdb# Uncomment the following if you are using Innobase tables #skip-innodb innodb_data_home_dir = e:/mysql/ibdata #该目录一定要事先建好 innodb_data_file_path = ibdata1:300M # 数据文件必须能容下数据和索引 set-variable = innodb_buffer_pool_size=50M # 设置缓冲池大小为内存的 50 - 80 % set-variable = innodb_additional_mem_pool_size=5M innodb_log_group_home_dir = e:/mysql/ibdata/iblogs innodb_log_arch_dir = e:/mysql/ibdata/iblogs # log_arch_dir 必须和 log_group_home_dir 一样 innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M # 设置日志文件大小为缓冲池的 15%。 set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 # 如果丢失最近的几个事务影响不大的话,设置 flush_log_at_trx_commit 为 0。 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 set-variable = have_innodb=Yes
1: mysql> SHOW VARIABLES LIKE "have_%"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_bdb | YES | | have_innodb | NO | | have_isam | YES | | have_raid | NO | | have_openssl | NO | +---------------+-------+ The meaning of the values are: Value Meaning YES The option is activated and usable. NO MySQL is not compiled with support for this option. DISABLED The xxxx option is disabled because one started mysqld with --skip-xxxx or because one didn't start mysqld with all needed options to enable the option. In this case the hostname.err file should contain a reason for why the option is disabled. 2: set-variable = have_innodb=Yes 这一行不需要3: [WinMySQLAdmin] Server=E:/MYSQL/bin/mysqld-opt.exe mysqld-opt.exe并不支持事务型表引擎 你需要使用 mysqld-max.exe mysqld-max-nt.exe
改了my.ini文件,还是不行Server=E:/MYSQL/bin/mysqld-max.exe 查了一下error文件: 030314 10:00:51 Can't init databases InnoDB: Could not open data files InnoDB: than specified in the .cnf file! InnoDB: Error: data file e:\mysql\ibdata\ibdata1 is of a different size这个又是怎么解决? 请 shuixin13(犬犬(心帆)) 兄弟再次指点,谢谢。
呵呵, 出现这个错误 你的 mysql 服务一定启动不起来了, :)你需要确定是否存在e:\mysql\ibdata\ 目录, 如果该目录存在, 请将该目录下的所有文件删除,只保留一个空目录, 然后再重新启动 MySQL 服务
你的MySQL服务器版本??# Uncomment the following if you are using Innobase tables
#skip-innodb
#上一句一定要用#号注释了
innodb_data_home_dir = e:\mysql\ibdata
#该目录一定要事先建好
innodb_data_file_path = ibdata1:1000M
# 数据文件必须能容下数据和索引
是在http://www.mysql.com/downloads/mysql-3.23.html中download的描述如下:
Windows downloads
The Windows download contains both the Standard and Max server binaries. It also contains a version of the command-line client which uses the Cygwin library to provide command history and editing. Source code for the version of Cygwin we have used is available on this page.Windows 95/98/NT/2000/XP 3.23.55 13.3M Download | Pick a mirror
MD5: 95a9add0f228d0b60ce4ea28e7e02d9b 应该是包括了max是不是只能在2000下才能启动innodb? win98下不行?我的my,ini:里面所提及的目录我都手工创建了。[WinMySQLAdmin]
Server=E:/MYSQL/bin/mysqld-opt.exe
user=test
password=test[mysqld]
basedir=E:/MYSQL
#bind-address=10.21.106.198
datadir=E:/MYSQL/data
#language=E:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M#default-character-set=gb2312
log-bin = e:/mysql/log/123.log
# 二进制Log文件,用于镜像服务器
log =e:/mysql/log/sql.log
# Log记录
local-infile =1
# 允许使用 LOAD DATA LOCAL
#socket =MySQL
skip-lockingset-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_concurrency=2
# CPU数目*2
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1# Un comment the following if you are NOT using BDB tables
skip-bdb# Uncomment the following if you are using Innobase tables
#skip-innodb
innodb_data_home_dir = e:/mysql/ibdata
#该目录一定要事先建好
innodb_data_file_path = ibdata1:300M
# 数据文件必须能容下数据和索引
set-variable = innodb_buffer_pool_size=50M
# 设置缓冲池大小为内存的 50 - 80 %
set-variable = innodb_additional_mem_pool_size=5M
innodb_log_group_home_dir = e:/mysql/ibdata/iblogs
innodb_log_arch_dir = e:/mysql/ibdata/iblogs
# log_arch_dir 必须和 log_group_home_dir 一样
innodb_log_archive=0
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
# 设置日志文件大小为缓冲池的 15%。
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
# 如果丢失最近的几个事务影响不大的话,设置 flush_log_at_trx_commit 为 0。
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = have_innodb=Yes
mysql> SHOW VARIABLES LIKE "have_%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_bdb | YES |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
+---------------+-------+
The meaning of the values are: Value Meaning
YES The option is activated and usable.
NO MySQL is not compiled with support for this option.
DISABLED The xxxx option is disabled because one started mysqld with --skip-xxxx or because one didn't start mysqld with all needed options to enable the option. In this case the hostname.err file should contain a reason for why the option is disabled. 2:
set-variable = have_innodb=Yes
这一行不需要3:
[WinMySQLAdmin]
Server=E:/MYSQL/bin/mysqld-opt.exe
mysqld-opt.exe并不支持事务型表引擎
你需要使用
mysqld-max.exe
mysqld-max-nt.exe
查了一下error文件:
030314 10:00:51 Can't init databases
InnoDB: Could not open data files
InnoDB: than specified in the .cnf file!
InnoDB: Error: data file e:\mysql\ibdata\ibdata1 is of a different size这个又是怎么解决?
请 shuixin13(犬犬(心帆)) 兄弟再次指点,谢谢。
出现这个错误
你的 mysql 服务一定启动不起来了,
:)你需要确定是否存在e:\mysql\ibdata\ 目录,
如果该目录存在,
请将该目录下的所有文件删除,只保留一个空目录,
然后再重新启动 MySQL 服务