Jump to content

Broken Mysql Tables


armitaage

Recommended Posts

user: armitege

server: stevie

domain: armitaage2.heliohost.org

 

I have installed on my server piwik analytics, and for the most part it is working fine. Except, it seems, that 3 of the necessary tables have become corrupted some time in June. I can find them with SHOW TABLES, but I cannot browse their data in phpMyAdmin and the analytics software cannot find them either. After doing a search online, it seems that the most common cause of this sort of behavior occurs when an innoDB database is moved and some required files are incorrectly copied. I have not moved the database in question, and all of the uncorrupted tables in the database use MyISAM engine anyway, so my assumption is that the corrupted tables are also MyISAM. Repair database from the cpanel doesn't help, it returns the same error as piwik analytics.

 

The database in question is armitege_piwik433 and the corrupted tables are piwik_archive_numeric_2014_06, piwik_archive_numeric_2014_07, and piwik_archive_numeric_2014_08.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...