MySQL Error #1016: cant open file: *. myi. (errno: 145)

Source: Internet
Author: User
It's miserable to go to work on Saturday. A project on the JCS side is urgent. Let me do technical support in the past. They are too busy to stay up late.
When I first arrived at the company, I found my blog could not be opened. prompt SQL statement error. MySQL returns error can't open file *. myi thought it was done by someone. Then I opened several related pages and went to FTP to read the files. The analysis estimated that the program was still normal and not fully or hacked. open http: // */phpMyAdmin and check that everything is normal. However, when you open the * _ blog database, the * _ blogs table shows that it is in use and cannot be browsed or viewed, no table data size statistics are available. blank. I feel a bit confused. it's not because the database has been involved. It should be impossible. it is estimated that there is still a problem with the database.
OK. Open the * _ blogs table. The returned result is the #1016 can't open file error.
Open the SQL window, enter check table * _ blogs, and the system prompts one warning, one corrupt, and two errors.
Locate the problem. Open the SQL window and enter repair table * _ blogs.
Go back to the database browsing page. All the tables are normal. Refresh the blog page. You can work with hoho.
............

Tags-MySQL
Source: http://boylee.net/read.php? 253

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.