MySQL table marked as crashed and should be repaired

MySQL table marked as crashed and should be repaired

MySQL table marked as crashed and should be repaired

Category: Recovery Interface &nbsp

If you are getting the following error message:

Table ‘jos151_session’ is marked as crashed and should be repaired

this means mysql service was terminated while this particular table was open to write some data into it. After mysql start/restart some data is in inconsistent state.

To fix the problem you need to log into mysql, select necessary database and run:

# CHECK TABLE jos151_session;
# REPAIR TABLE jos151_session;

If more than one table is broken, you may run check/repair for all tables in databases with bash command line and providing root password:

mysqlcheck -A -or -p

    • Related Articles

    • How To Store InnoDB Data In One File Per Table

      To achieve faster performance of MySQL server with InnoDB engine and for I/O optimization one can choose file-per-table mode. InnoDB storage engine stores all data for tables in a common tablespace. It is possible to configure InnoDB to store data ...

    • Configure MySQL Master-Master replication

      Configure MySQL Master-Master replication Category: Databases &nbsp Configuring MySQL in a master-slave replicate model adds complexity to the application utilizing the database. The application has to be programmed to send the write queries only to ...

    • Galera MySQL Recommended Cluster Configuration

      Galera/MySQL recommended cluster configuration Category: Template Information &nbsp For practical purposes Galera/MySQL vendor recommend to reserve a “Reference Node” in the cluster. We propose the cluster looks like: Reference Node cluster A ...

    • How to add a MySQL database to Cloud Hosting

      How to add a MySQL database to Cloud Hosting (also, adding a user, and adding a user to the db) Category: Getting Started &nbsp This how-to will show you how to: ♦ Add a MySQL Database to our cloud hosting ♦ Add a user to the mysql userbase ♦ Add a ...

    • How to add a MySQL database to Cloud Hosting

      How to add a MySQL database to Cloud Hosting (also, adding a user, and adding a user to the db) Category: Getting Started &nbsp This how-to will show you how to: ♦ Add a MySQL Database to our cloud hosting ♦ Add a user to the mysql userbase ♦ Add a ...