我需要一些解决方案来解决我的wordpress网站数据库错误。我上个月遇到过这个数据库错误。我不知道这个数据库连接错误的原因是什么。请查看我error.log提供的后续内容。
2018-06-19 15:59:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-06-19 15:59:16 4297 [Note] Plugin 'FEDERATED' is disabled.
2018-06-19 15:59:16 4297 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-19 15:59:16 4297 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-19 15:59:16 4297 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-19 15:59:16 4297 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-06-19 15:59:16 4297 [Note] InnoDB: Using Linux native AIO
2018-06-19 15:59:16 4297 [Note] InnoDB: Using CPU crc32 instructions
2018-06-19 15:59:16 4297 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2018-06-19 15:59:16 4297 [Note] InnoDB: Completed initialization of buffer pool
2018-06-19 15:59:16 4297 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-19 15:59:16 4297 [Note] InnoDB: The log sequence numbers 50223779105 and 50223779105 in ibdata files do not match the log sequence number 50225310342 in the ib_logfiles!
2018-06-19 15:59:16 4297 [Note] InnoDB: Database was not shutdown normally!
2018-06-19 15:59:16 4297 [Note] InnoDB: Starting crash recovery.
2018-06-19 15:59:16 4297 [Note] InnoDB: Reading tablespace information from the .ibd files...
答案1
首先检查托管数据库的服务器的正常运行时间，可能是由于某种原因，您的服务器正在重新启动，如果正常运行时间正常，则需要检查是否存在任何 HDD 或内存问题，检查是否有坏块或 RAM 错误
您可以尝试使用“mysqlcheck --auto-repair -o --all-databases”修复 mysql DB/表
你应该添加一个 cron 任务来每天备份你的数据，以防 mysql 恢复失败，你可以恢复