mysql win2008_求助:win2008下mysql5.1服务不能启动

在服务管理器里启动mysql服务报错为                  1607:进程意外终止。

mysql的端口为9902,防火墙已经允许了9901到9905端口的通信。

mysql的配置文件my.ini 如下:

[client]

port=9902

[mysql]

default-character-set=utf8

[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=9902

basedir="C:/Program Files/MySQL/mysql5.1/9002/"

datadir="D:/Data/9902/"

#tmpdir="D:/Data/9902/"

character-set-server=utf8

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=10000

query_cache_size=18M

table_cache=1400

tmp_table_size=16M

thread_cache_size=38

#*** MyISAM Specific options

myisam_max_sort_file_size=8M

myisam_sort_buffer_size=25M

key_buffer_size=256K

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256K

#*** INNODB Specific options ***

innodb_data_home_dir="D:/Data/9902/"

innodb_additional_mem_pool_size=12M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=6M

innodb_buffer_pool_size=2048M

innodb_log_file_size=10M

innodb_thread_concurrency=18

group_concat_max_len = 200000

log_bin="d:/mysql_log/mysql9902_bin"

binlog_ignore-db=mysql,test

max_binlog_size=300M

binlog_format=mixed

innodb_flush_log_at_trx_commit=2

thread_stack=10M

join_buffer_size=1M

read_rnd_buffer_size=1M

mysql的错误日志信息如下:

121120 17:14:21 [Note] Plugin 'FEDERATED' is disabled.

121120 17:14:21  InnoDB: Initializing buffer pool, size = 2.0G

121120 17:14:22  InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file D:\Data\9902\ibdata1 did not exist:

InnoDB: a new database to be created!

121120 17:14:22  InnoDB: Setting file D:\Data\9902\ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

121120 17:14:22  InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 10 MB

InnoDB: Database physically writes the file full: wait...

121120 17:14:22  InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

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

121120 17:14:23  InnoDB: Started; log sequence number 0 0

121120 17:14:23 [ERROR] Aborting

121120 17:14:23  InnoDB: Starting shutdown...

121120 17:14:29  InnoDB: Shutdown completed; log sequence number 0 44233

121120 17:14:29 [Note]

121120 17:53:04 [Note] Plugin 'FEDERATED' is disabled.

121120 17:53:05  InnoDB: Initializing buffer pool, size = 2.0G

121120 17:53:05  InnoDB: Completed initialization of buffer pool

121120 17:53:06  InnoDB: Started; log sequence number 0 44233

121120 17:53:06 [ERROR] Aborting

121120 17:53:06  InnoDB: Starting shutdown...

121120 17:53:12  InnoDB: Shutdown completed; log sequence number 0 44233

121120 17:53:12 [Note]

121120 17:56:06 [Note] Plugin 'FEDERATED' is disabled.

121120 17:56:06  InnoDB: Initializing buffer pool, size = 2.0G

121120 17:56:06  InnoDB: Completed initialization of buffer pool

121120 17:56:07  InnoDB: Started; log sequence number 0 44233

121120 17:56:07 [ERROR] Aborting

121120 17:56:07  InnoDB: Starting shutdown...

121120 17:56:13  InnoDB: Shutdown completed; log sequence number 0 44233

121120 17:56:13 [Note]

在网上找了N多办法都没有解决,可以正常创建日志和innodb数据文件,但是服务就是启动不了,求哪位大侠帮看看这是怎么回事

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值