[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 tried reinstalling again.
>
>
>error log is now as before.
>
>
>interesting in the details while mysql was installing I saw  "Unknown job: mysql"
>
>
>if I run 
>sudo service mysql restart
>
>
>I get
>Rather than invoking init scripts through /etc/init.d, use the service(8)
>utility, e.g. service mysql restart
>
>
>Since the script you are attempting to invoke has been converted to an
>Upstart job, you may also use the stop(8) and then start(8) utilities,
>e.g. stop mysql ; start mysql. The restart(8) utility is also available.
>start: Unknown job: mysql
>
>
>Is there a clue in the above?
>
>
>sudo start mysql 
>gives
>start: Unknown job: mysql
>
>
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120601/4bfc94fd/attachment-0001.html>