mysql启动不了，求大神指点，感激不尽！

[caffrey11]

2017-10-09T01:42:06.484929Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2017-10-09T01:42:42.000990Z mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data
2017-10-09T01:42:42.157912Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-09T01:42:42.157977Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-10-09T01:42:42.157996Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.16-log) starting as process 21895 ...
2017-10-09T01:42:42.161194Z 0 [Note] InnoDB: PUNCH HOLE support not available
2017-10-09T01:42:42.161213Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-09T01:42:42.161216Z 0 [Note] InnoDB: Uses event mutexes
2017-10-09T01:42:42.161220Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-10-09T01:42:42.161228Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-09T01:42:42.161230Z 0 [Note] InnoDB: Using Linux native AIO
2017-10-09T01:42:42.161378Z 0 [Note] InnoDB: Number of pools: 1
2017-10-09T01:42:42.161442Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-10-09T01:42:42.181498Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-10-09T01:42:42.186230Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-10-09T01:42:42.187139Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-10-09T01:42:55.945202Z 0 [Warning] InnoDB: 1048576 bytes should have been read. Only 917504 bytes read. Retrying for the remaining bytes.
2017-10-09T01:43:09.891588Z 0 [Warning] InnoDB: Retry attempts for reading partial data failed.
2017-10-09T01:43:10.079210Z 0 [ERROR] InnoDB: Tried to read 1048576 bytes at offset 2097152, but was only able to read 917504
2017-10-09T01:43:10.079224Z 0 [ERROR] InnoDB: Operating system error number 5 in a file operation.
2017-10-09T01:43:10.079236Z 0 [ERROR] InnoDB: Error number 5 means 'Input/output error'
2017-10-09T01:43:10.079241Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2017-10-09T01:43:10.079246Z 0 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation
2017-10-09T01:43:10.079250Z 0 [ERROR] InnoDB: Cannot continue operation.
2017-10-09T01:43:10.384121Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[rucypli]

先看下操作系统是否正常 然后尝试用innodb_force_recovery来启动 然后导出数据

[ACMAIN_CHM]

结帖率：0% 当您的问题得到解答后请及时结贴. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html 8、如何给分和结贴？ http://bbs.csdn.net/help#post_dispose

[caffrey11]

innodb_force_recovery 1-6全试了还是启动不了，重新建库了，还好是测试库。