After power failure my HDD with all backups died, and database server (10.1.17-MariaDB on UBUTNU 14.04) with piwik database started experience various errors:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111 “Connection refused”)
ERROR 2006 (HY000): MySQL server has gone away
ERROR 2013 (HY000): Lost connection to MySQL server during query
ERROR 1396 (HY000): Operation CREATE USER failed for…
SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111 “Connection refused”)
have corrupted table “piwik_log_link_visit_action”
…etc…
somehow I managed to export all tables except one: piwik_log_link_visit_action
check table piwikdb.piwik_log_link_visit_action; returns:
±------------------------------------±------±---------±--------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±------------------------------------±------±---------±--------------------------------------------------------------------+
| piwikdb.piwik_log_link_visit_action | check | Error | Table ‘piwikdb.piwik_log_link_visit_action’ doesn’t exist in engine |
| piwikdb.piwik_log_link_visit_action | check | status | Operation failed |
±------------------------------------±------±---------±--------------------------------------------------------------------+
REPAIR TABLE or OPTIMIZE TABLE doesnt help…
after looking for local files into /var/lib/mysql/piwikdb/ I found out that there is nothing for piwik_log_link_visit_action …does anybody have any idea how to retrieve the piwik_log_link_visit_action ???