[mythtvnz] I killed MYSQL now what?

[Steve V]

The mantra of don't fix it if it isn't broken and don't upgrade if you don't have to worked for me for a couple of years.

But then I went and upgraded - from Ubuntu 10.04 to Ubuntu 11.10, actually that went fine, a few minor display driver issues but easily fixed. Myth was working fine after this upgrade for a week.

Then I noticed that my squeezeserver was no longer working and found out it is not compatible with 11.10 and was now released as Logitech media Server (LMS). It should have been a clue that it was only available as a deb install - not available via apt.

I can't be absolutely sure that is because of LMS but since installing LMS, Myth has not worked.

The specific fault for Myth is that MYSQL will not start.

so far I have:
Uninstalled LMS
Completely removed MYSQL-Server and anything else I could find that was MYSQL
This also removes Myth.
Deleted my.cnf
Reinstalled MYSQL and Myth but still have the same problem with MYSQL not starting.

The only relevant log file I have shows mysql shutting down due to a InnoDB error (at least that is what I think this means).

120601 20:47:23 [Note] Plugin 'FEDERATED' is disabled.
120601 20:47:23  InnoDB: Initializing buffer pool, size = 8.0M
120601 20:47:23  InnoDB: Completed initialization of buffer pool
120601 20:47:23  InnoDB: Started; log sequence number 0 279056
120601 20:47:23  InnoDB: Starting shutdown...
120601 20:47:28  InnoDB: Shutdown completed; log sequence number 0 279056
120601 20:47:28 [Note] Plugin 'FEDERATED' is disabled.
120601 20:47:28  InnoDB: Initializing buffer pool, size = 8.0M
120601 20:47:28  InnoDB: Completed initialization of buffer pool
120601 20:47:28  InnoDB: Started; log sequence number 0 279056
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
120601 20:47:28 [ERROR] Aborting

120601 20:47:28  InnoDB: Starting shutdown...
120601 20:47:34  InnoDB: Shutdown completed; log sequence number 0 279056
120601 20:47:34 [Note] /usr/sbin/mysqld: Shutdown complete

120601 20:47:34 [Note] Plugin 'FEDERATED' is disabled.
120601 20:47:34  InnoDB: Initializing buffer pool, size = 8.0M
120601 20:47:34  InnoDB: Completed initialization of buffer pool
120601 20:47:34  InnoDB: Started; log sequence number 0 279056
120601 20:47:34  InnoDB: Starting shutdown...
120601 20:47:39  InnoDB: Shutdown completed; log sequence number 0 279056
120601 20:47:39 [Note] Plugin 'FEDERATED' is disabled.
120601 20:47:39  InnoDB: Initializing buffer pool, size = 8.0M
120601 20:47:39  InnoDB: Completed initialization of buffer pool
120601 20:47:39  InnoDB: Started; log sequence number 0 279056
ERROR: 1050  Table 'plugin' already exists
120601 20:47:39 [ERROR] Aborting

120601 20:47:39  InnoDB: Starting shutdown...
120601 20:47:44  InnoDB: Shutdown completed; log sequence number 0 279056
120601 20:47:44 [Note] /usr/sbin/mysqld: Shutdown complete

Does anyone have any ideas?


Cheers

Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120601/15ecbfab/attachment-0001.html>