-
MySQL Error: Checking for corrupt, not cleanly closed and upgrade needing tables
Hi,
I just reset mysql's password to be empty. It's a virtual machine so I don't care of the security.
After the mysqld restart I got this error "Checking for corrupt, not cleanly closed and upgrade needing tables."
I also did the following to repair the tables and the error is still the same.
root@plesk:/var/lib/mysql/mysql# myisamchk --recover *.MYI
root@plesk:/var/lib/mysql/mysql# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
-
The recovery plan is following
Split corrupted InnoDB tablespace into pages; sort the pages by type and index_id
Fetch records from PRIMARY index of the table
DROP corrupted table and create new one
Load records back into MySQL
Also you may visit the branch where the similar issue was resolved http://www.sqlservercentral.com/Foru...684-384-1.aspx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|