Table is marked as crashed Print

  • diskspace, database, backup, cpanel, phpmyadmin, restore, woocommerce, support
  • 0

A table needs repair.

WHAT IT MEANS

The table was left in an inconsistent state, usually by an interrupted write.

COMMON CAUSES

The server was interrupted during a write Disk space ran out A very large operation was terminated partway

REPAIRING IT

cPanel > phpMyAdmin. Select the database, tick the affected table, and choose Repair table from the operations dropdown.

This resolves most cases without data loss.

IF REPAIR FAILS

Restore the table, or the database, from a backup.

IF IT RECURS

Something is causing repeated interruption. Check disk space first, since a full disk is a common cause.

Open a ticket if it continues; repeated corruption may indicate a server-side issue we should look at.

BEFORE REPAIRING

Export the table if you can. Repair usually works and occasionally loses rows.

PREVENTING IT

Watch disk space. A full account causes writes to fail partway, which is the most common cause of this.

Keep backups, which make the whole question less serious.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot