This article summarizes the solutions to MYSQL is marked as crashed and should be repaired. Friends in need can refer to it. problem analysis As for the cause of the error, some netizens said that it was an index error caused by frequent querying and updating of the [data table] table. Because my page was not statically generated, but a dynamic page, I quite agree with this statement. It is also said that the MYSQL database has been damaged for some reason. For example, a sudden power outage of the database server, some operation on the original file of the table when providing services to the database table may cause the MYSQL database to be damaged. The table is corrupted and the data cannot be read. In short, the watch is damaged due to some unfathomable problems. Solution The fix is as follows. Find myisamchk under your mysql/bin. Enter at the command line: code show as below Copy code myisamchk -c -r d:mysqldataabc.MYI That’s it :) Foreign
1. MYSQL is marked as crashed and should be repairedSolution
Introduction: This article summarizes the information about MYSQL is Friends in need can refer to the solution marked as crashed and should be repaired.
2. Solution to "mysqld is dead but subsys is locked" when installing MYSQL on Red Hat Linux 9
Introduction: Today I installed MYSQL on Red Hat Linux 9, but after service mysql start, the following prompt appears when checking service mysql status: mysqld
3. mysql_stat() queries the current system status of the MySQL server
Introduction: mysql tutorial: mysql_stat() queries the current system status of the MySQL server Definition and usage mysql_stat() function returns the current status of the MySQL server system status. If successful, the function returns status. On failure, returns false. Syntax mysql_stat(connection) Parameter description connection can
4. Basic introduction to MySQL database commands
Introduction: The following The article is mainly a detailed analysis of the basics of MySQL database commands. We first start by displaying the basic information of the MySQL database to conduct a detailed analysis of the basics of the MySQL database commands. The following is a description of the specific content of the article. Display basic MySQL information: MySQL status; View variables: showvariableslike'%ver
5. View the default encoding of the MySQL database
Introduction: Check the default encoding of the MySQL database. Use the status command to display the related information of the database. The example is as follows: mysql status; ———— mysql Ver 14.12 Distrib 5.0.77, for Win32 (ia32) Connectionid: 1072 Current database : Currentuser: test@119.119.247.6 SSL: Not in use Usin
Introduction :001 Check the version mysql --version mysql select version(); mysql status; 002 Create a new MySQL user and authorize insert into mysql.user(Host,User,Password) values(localhost,username,password(yourpassword)); GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
Introduction: [shengting @login ~]$ mysql -V mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686) 2: In mysql: mysql status; The following is the code snippet: mysql status; -------- ------ mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686) Connection id:
8. The best choice of MySQL data types
Introduction: Welcome to the Linux Community Forum, interact with 2 million technical staff>>Enter 5 rows in set (0.06 sec) mysql status; ---- ---------- mysql Ver 14.14 Distrib 5.5.16, for Linux (i686) using EditLine wrapper Connection id: 1 Current database: information_schema Curre
##9. Cannot open mysql on ubuntu server, please answer online!
Introduction: When querying the status, it prints the following xxx@r10f17332:~$ service mysql status mysql stop/waiting. When it starts, it prints the following xxx@r10f17332:~$ service mysql start start: Rejected send message, 1 matched rules ; type="method_call", sender=":1.114" (uid=121493 pid=29149 comm=&quo
10. MySQL 5.0 New Features Tutorial Stored Procedure: Second Talk_MySQL
Introduction: Author: mysql AB; Translation: Chen Pengyi Why MySQL Statements are Legal in a Procedure Body What MySQL statements are legal in a stored procedure body? What kind of SQL statements are legal in Mysql stored procedures? You can create a statement that contains INSERT, UPDATE, DELETE, SELECT, DROP, CREATE, REPLACE, etc. Your only
.The above is the detailed content of 10 recommended articles about the mysql_stat() function. For more information, please follow other related articles on the PHP Chinese website!