[mythtvnz] I killed MYSQL now what?

[David Moore]

On 01/06/12 22:39, Steve V wrote:
>
>
>     ------------------------------------------------------------------------
>     *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
>     <mailto: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
>
Do you have a mysql.conf file in /etc/init/? Upstart needs this. Also 
mysql has apparmor complications which might be screwing with you.