mysql还原后启动出问题

2018-04-15 15:18:11 24653 [Note] Plugin 'FEDERATED' is disabled.
2018-04-15 15:18:11 24653 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-15 15:18:11 24653 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-15 15:18:11 24653 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-15 15:18:11 24653 [Note] InnoDB: Memory barrier is not used
2018-04-15 15:18:11 24653 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-15 15:18:11 24653 [Note] InnoDB: Using Linux native AIO
2018-04-15 15:18:11 24653 [Note] InnoDB: Using CPU crc32 instructions
2018-04-15 15:18:11 24653 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-15 15:18:11 24653 [Note] InnoDB: Completed initialization of buffer pool
2018-04-15 15:18:11 24653 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-04-15 15:18:11 24653 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-04-15 15:18:12 24653 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-04-15 15:18:12 24653 [Warning] InnoDB: New log files created, LSN=48585617787
2018-04-15 15:18:12 24653 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-15 15:18:12 7ffa03794740 InnoDB: Error: page 7 log sequence number 254015752729
InnoDB: is in the future! Current system log sequence number 48585617932.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2018-04-15 15:18:12 7ffa03794740 InnoDB: Error: page 1 log sequence number 249801886007
InnoDB: is in the future! Current system log sequence number 48585617932.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2018-04-15 15:18:12 7ffa03794740 InnoDB: Error: page 3 log sequence number 73815057441
InnoDB: is in the future! Current system log sequence number 48585617932.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See

是在linux中装的吗?

完全恢复数据库中的表和数据,停掉数据库,可以吧数据的目录名相应的改成原来的

1、在MY.INI文件中的 [mysqld] 中增加一行
tmpdir="D:/MySQL/data/"
修改后,还是启动不了或者能启动但关机后又出现同样问题,接着我做了第二步,重启正常。

2、删除DATA目录下除数据库文件夹外的其他文件,重启mysql,问题解决。

服务中重新启动mysql服务,或者重新配置一下mysql

谢谢各位,找到原因了,是server_id=1 , 这里的值设置成1 就ok, 不能设置成其它值