Fixing broken tables

Common MySQL table issues

Common problems in this class include:

  • broken auto-increments
  • corrupt indexes

Methods of fixing them are as follows:

  • running a repair on the table from phpMyAdmin’s Operations tab or executing REPAIR TABLE tablename; phpMyAdmin’s SQL tab
  • Doing a repair from your hosting control panel’s databases page (if they don’t offer phpMyAdmin)
  • Manually running REPAIR TABLE tablename; from within mysql from the command line on your server, if you have ssh access.

Still have questions? Use the Search box in the upper right, or try the full list of FAQs. If you can't find it there, head over to the Zen Cart support forum and ask there in the appropriate subforum. In your post, please include your Zen Cart and PHP versions, and a link to your site.

Is there an error or omission on this page? Please post to General Questions on the support forum. Or, if you'd like to open a pull request, just review the guidelines and get started. You can even PR right here.
Last modified March 5, 2021 by Scott C Wilson (16a66e8).