MYSQL error: Can 'topenfile: '×××. myi' (errno: 145) [group _ MySQL

Source: Internet
Author: User
MYSQL error: Can 'topenfile: '×××. myi' (errno: 145) [group chart] This error is caused by damage to a typical mysql table. the solution is to repair the table, which is also common in mysql, the possibility of damage to mysql tables and indexes is very high, but the repair is also very convenient. the solution to reduce such problems is to minimize the server power failure for no reason. when the server is shut down, the mysql database is closed manually.

Let's take a look at this problem:

Can 'topenfile: '×××. myi' (errno: 145). This error is generally caused by damage to your database table files, probably because you moved the database files, of course, other reasons are not excluded.

The error code for the specific database is as follows:

InvalidSQL :......

MySQL error! : 1016 (Can 'topenfile: '×××. myi' (errno: 145 ))

There are multiple solutions to this problem. if your database can be remotely linked or you can connect to your remote server desktop and your server system is Windows, you can:

Run-> cmd

Then: mysql

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.