Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to solve the problem that the MySQL data table displayed by phpmyadmin is still invalid after being repaired?

2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

Editor to share with you how to solve the phpmyadmin display MySQL data table "in use" after the repair is still invalid, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

What are the characteristics of php 1, the execution speed is fast. 2. It has good openness and expansibility. 3. PHP supports a variety of mainstream and non-mainstream databases. Object-oriented programming: PHP provides classes and objects. 5. The update speed of the version is fast. 6. It has rich functions. 7. Scalability. 8. Comprehensive functions, including graphics processing, encoding and decoding, compressed file processing, xml analysis and so on.

PHP+MySQL background, part of the program page does not display content, error prompt error, need to be repaired.

Open phpmyadmin to select a database to view, and sure enough, three tables are displayed as "in use". Check the box to "repair the table". An error indicates that it cannot be repaired.

So starting from the "analysis table" and the "optimization table", they all failed. The first item of failure message: can't create new temp file

Google solution: force repair of myisamchk-r-f *. MYI, the problem remains.

Step 1: stop the MYSQL service, cmd command: net stop mysql.

Step 2: be safe and back up the entire database folder.

Step 3: open the folder where the database is located, find the file automatically generated by the system of the damaged table (xxxx.TMD) and rename it (xxx.MYD).

Step 4: execute the repair command: myisamchk-r D:/MYSQLdata/ database name * .MYI (remember: the mysql service is stopped here) requires the CMD command to enter the bin directory of mysql

Step 5: start the MYSQL service, net start mysql.

Step 6: execute the command again: mysqlcheck-o-r database name-u root-p (change it to your MYSQL administrator name as appropriate), and prompt for your password after running.

Continuing to check for write permissions also does not solve the problem.

Finally, only consider whether there is not enough disk space to write? Check the drive letter capacity, and sure enough. The problem is resolved automatically after the disk is cleaned.

The above is all the contents of the article "how to solve the problem that is still invalid after being repaired" in the use of phpmyadmin display MySQL data table. thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 299

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report