$ mysql -u ****piwik -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7128
Server version: 5.0.51a-24+lenny4 (Debian)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use hoppiwik
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> check table log_link_visit_action;
+--------------------------------+-------+----------+------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------+-------+----------+------------------------------------------------------+
| hoppiwik.log_link_visit_action | check | Error | Table 'hoppiwik.log_link_visit_action' doesn't exist |
| hoppiwik.log_link_visit_action | check | error | Corrupt |
+--------------------------------+-------+----------+------------------------------------------------------+
2 rows in set (0.04 sec)
mysql> repair table log_link_visit_action;
+--------------------------------+--------+----------+------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------+--------+----------+------------------------------------------------------+
| hoppiwik.log_link_visit_action | repair | Error | Table 'hoppiwik.log_link_visit_action' doesn't exist |
| hoppiwik.log_link_visit_action | repair | error | Corrupt |
+--------------------------------+--------+----------+------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> check table log_link_visit_action;
+--------------------------------+-------+----------+------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------+-------+----------+------------------------------------------------------+
| hoppiwik.log_link_visit_action | check | Error | Table 'hoppiwik.log_link_visit_action' doesn't exist |
| hoppiwik.log_link_visit_action | check | error | Corrupt |
+--------------------------------+-------+----------+------------------------------------------------------+
2 rows in set (0.04 sec)
mysql>
Sorry to bug you but I am just bumping this. If the piwik link in my previous post doesn’t help me then my next option will be to used a backed up database back from a few weeks ago. I can’t remember now what version this back up was from but anyway the corrupted database is 1.9.1. If I restore the pre 1.9.1 database will it update ok to 1.9.1?
You can try to run the command put in the other forum post but I think it’s similar to CHECK TABLE command you run earlier. I would recommend restoring the table from your backup. There might be missing schema updates so let’ssee errors you get & you can find schema updates in piwik/core/Updates/1.9*** if any