小白建站日记,再也不敢乱删数据库了,呜呜呜

查看 41|回复 2
作者:IT小埋   
网站用的内存很小,只有30GB的空间,今天想清除一下数据,把之前测试的,没用的数据库都删掉,没想到这一删除好了,直接导致服务器mysql服务停止运行,网站无法访问。在宝塔后台再次启动时,却显示mysqld无法启动服务。
查了网上很多资料,包括宝塔论坛,问了AI都没有特别理想的解决方案。本小白索性直接看二进制日志,然后看到日志显示:2023-06-08T08:48:33.640872Z 0 [ERROR] InnoDB: Tablespace 25775 was not found at ./ai_image/*******,虽然不知道啥意思,但是ai_image是我之前创建的一个数据库,OK,恢复它(还好开启了删除回收站功能,呜呜呜呜)
网站终于好了。吊大的药友解释解释?
部分日志如下:
2023-06-08T08:48:33.639567Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 581750914
2023-06-08T08:48:33.640114Z 0 [Note] InnoDB: Database was not shutdown normally!
2023-06-08T08:48:33.640159Z 0 [Note] InnoDB: Starting crash recovery.
2023-06-08T08:48:33.640786Z 0 [ERROR] InnoDB: Tablespace 25778 was not found at ./ai_image/FTS_00000000000064b8_0000000000000dd4_INDEX_1.ibd.
2023-06-08T08:48:33.640805Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2023-06-08T08:48:33.640817Z 0 [ERROR] InnoDB: Tablespace 25783 was not found at ./ai_image/FTS_00000000000064b8_0000000000000dd4_INDEX_6.ibd.
2023-06-08T08:48:33.640837Z 0 [ERROR] InnoDB: Tablespace 25763 was not found at ./ai_image/FTS_00000000000064ac_CONFIG.ibd.
2023-06-08T08:48:33.640847Z 0 [ERROR] InnoDB: Tablespace 25766 was not found at ./ai_image/FTS_00000000000064ac_0000000000000dc4_INDEX_1.ibd.
2023-06-08T08:48:33.640861Z 0 [ERROR] InnoDB: Tablespace 25771 was not found at ./ai_image/FTS_00000000000064ac_0000000000000dc4_INDEX_6.ibd.
2023-06-08T08:48:33.640872Z 0 [ERROR] InnoDB: Tablespace 25775 was not found at ./ai_image/FTS_00000000000064b8_CONFIG.ibd.
2023-06-08T08:48:33.641973Z 0 [ERROR] InnoDB: Cannot continue operation.

数据库, 好了

芳心纵火犯   
慌啥,旧的不去新的不来,大不了做个新站。
流失的梦   
坚持每日备份
您需要登录后才可以回帖 登录 | 立即注册

返回顶部