DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: MySQL Error: Checking for corrupt, not cleanly closed and upgrade needing tables

  1. #1
    Join Date
    Apr 2015
    Posts
    1

    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.

  2. #2
    Join Date
    Apr 2015
    Posts
    1
    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
  •  


Click Here to Expand Forum to Full Width