[mythtvnz] I killed MYSQL now what?

[Steve V]

>________________________________
> From: Steve Hodge <stevehodge at gmail.com>
>To: MythTV in NZ <mythtvnz at lists.linuxnut.co.nz> 
>Sent: Friday, 1 June 2012 9:36 PM
>Subject: Re: [mythtvnz] I killed MYSQL now what?
> 
>
>On Fri, Jun 1, 2012 at 9:10 PM, criggie <criggie at criggie.org.nz> wrote:
>
>On 01/06/12 21:00, Steve V wrote:
>>
>>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
>>>
Something tried to change the table called user by adding a column called Show_view_priv but something's wrong with the command.
>>
>>
>>
>>
>>ERROR: 1050 Table 'plugin' already exists
>>>
Something's trying to create a table in the database called plugin, and it already exists.
>Both "user" and "plugin" are mysql system tables. It looks like something is trying to upgrade the mysql core schema and failing. The Show_view_priv column was added in 5.0.1. The plugin table was added in 5.1. What version do you have installed?
>
>What is interesting is that from the log it looks like it's gone through a couple of shutdown/startup cycles. And the second time it failed at a different point in the upgrade script. Do you still get the same error now?
>
>Cheers,
>Steve
>
>>> I have installed versio 5.1
>
>
>>>I added skip-innodb to my.cnf then rebooted the pc.
>
>
>>>There was no addition to the error log file, but mysql is still not running.
>>> ps -aef |grep mysql  does not show any mysql running.
>
>
>>>I have rebooted the PC twice since removing the skip-innodb line and there is still no addition to that log. Almost like it is no longer trying to start mysql. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120601/0c8ed040/attachment.html>