MySQL database table '. Phome_ecms_news ' is marked as crashed and last (automatic?) Workaround

Source: Internet
Author: User
Keywords Web programming MySQL Tutorial
Tags automatic broken command line directory find host index it is

Last night, the site's msql suddenly a bit of a problem, the index of the article is broken, looking for a long time to finish

Baidu search, said to repair the damaged table with phpMyAdmin, according to do, the problem is not resolved,

Helpless district official Find the answer, finally solved, the harm of my cold did not wear clothes for half an hour!

If your server is a stand-alone host, it is strongly recommended that you repair it using the command-line method:
Stop the MySQL service before fixing it.
If it is a win host, open the command line and go to MySQL's Bin directory.
Perform Myisamchk-r d:mysqldatadiscuz*. Myi
where d:mysqldatadiscuz the path to your database.
If it is a Unix-like host, use the MYISAMCHK-R database directory * directly. Myi.

When I use the second method, the table is being used in phpMyAdmin and the phpMyAdmin repair operation cannot repair the table. That's the third way, friend server with the win server host, so open the command line, first stop MySQL service: net stop MySQL, and then into the MySQL bin directory, input: Myisamchk-r d:mysqldatadiscuz*. Myi, if you can confirm which table, you can also put the previous * number directly to the specific table name, general repair no problem. After the carriage return is determined, the repair process is in a table of one table, one row after another.

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.