求救！！！！！！！！！！

shanshuilang

下面是最后的日志：
090911 10:54:23 [ERROR] The update log is no longer supported by MySQL in version 5.0 and above. It is replaced by the binary log.
090911 10:54:24  InnoDB: Started; log sequence number 3 2553461794
090911 10:54:24 [Note] Event Scheduler: Loaded 0 events
090911 10:54:24 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090911 10:59:22 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

090911 10:59:22 [Note] Event Scheduler: Purging the queue. 0 events
090911 10:59:23  InnoDB: Starting shutdown...
090911 10:59:25  InnoDB: Shutdown completed; log sequence number 3 2553461794
090911 10:59:25 [Warning] Forcing shutdown of 1 plugins
090911 10:59:25 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

下面是现在重复的错误日志：
090917 15:32:52  InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name D:\MySQL Datafiles\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

wiliiwin

那就是数据丢失了啊

shanshuilang

算了，放弃

shanshuilang

1.原来数据目录下面没有有ibdata0 这个文件
2.当前 数据目录下面没有以数据库名字的文件夹
3.新的配置文件的能够使用以前建立的用户名和密码登入
4.show engine报错：
ERROR 1064(42000):You have a error in your SQL synax; check the manual that corresponds to youe MySQL server Version for the right syntax to use near '' at line 1

wiliiwin

innodb_log_file_size 估计是你配置文件限制了日志文件大小 第一个文件超过了这个数值 就会生成新的日志文件  你数据目录下面是不是有ibdata0 这个文件的   很奇怪啊 日志不会导致进入mysql看不到数据的啊 你数据目录下面有没有以数据库名字的文件夹,看下文件夹里面有没有文件 再一个启动mysql 然后连接进去 执行 show engine;  把执行的结果贴出来.

shanshuilang

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090917 17:02:48  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090917 17:02:48 [ERROR] Plugin 'InnoDB' init function returned error.
090917 17:02:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090917 17:02:48 [Note] Event Scheduler: Loaded 0 events
090917 17:02:48 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community'  socket: ''  port: 3306  MySQL Community Server (GPL)

这是错误日志里面更新的内容。

shanshuilang

又新建了一个ibdata1（10m）………………

shanshuilang

好的，==

wiliiwin

   启动了 你show engine; 看下你数据支持的引擎,你把数据库停止了 然后把新生成的ibdata1改个名字 然后再重启服务 看什么情况.

shanshuilang

090712 21:38:47  InnoDB: Started; log sequence number 0 972203569
090712 21:38:47 [Note] Event Scheduler: Loaded 0 events
090712 21:38:48 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
090713  5:01:05 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown


这是以前的一个日志，里面有你说的InnoDB，不知道你是不是说这个？