Correct way fix system after database folder deletion
Hello!
Some time ago we have deleted database folder '/var/lib/mysql/db'. The disk was full and this was fastest solution to make free space on disk. We have no backup for the deleted database. After some time the following error was generated on '/var/log/mqsqlhost.err':
[ERROR] InnoDB: Tablespace open failed for '"db"."table"', ignored.
InnoDB: Operating system error number 2 in a file operation.
After searching with grep we have determined that 'ibdata1' file contains reference for the database. The question: What is correct way to clear entries about deleted database? Recreate and delete the database from WHM / comandline? Thanks!
After searching with grep we have determined that 'ibdata1' file contains reference for the database. The question: What is correct way to clear entries about deleted database? Recreate and delete the database from WHM / comandline? Thanks!
-
Hello, You can try recreating, then deleting, the database via the cPanel interface of the account. You may also find this thread helpful: InnoDB Corruption Repair Guide Thank you. 0
Please sign in to leave a comment.
Comments
1 comment