<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span><br></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Steve Hodge <stevehodge@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> MythTV in NZ <mythtvnz@lists.linuxnut.co.nz> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 1 June 2012 9:36 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [mythtvnz] I killed MYSQL now what?<br> </font> </div> <br><div id="yiv352484704"><div
class="yiv352484704gmail_quote">On Fri, Jun 1, 2012 at 9:10 PM, criggie <span dir="ltr"><<a rel="nofollow" ymailto="mailto:criggie@criggie.org.nz" target="_blank" href="mailto:criggie@criggie.org.nz">criggie@criggie.org.nz</a>></span> wrote:<br><blockquote class="yiv352484704gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="yiv352484704im">On 01/06/12 21:00, Steve V wrote:<br>
<blockquote class="yiv352484704gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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<br>
</blockquote></div>
Something tried to change the table called user by adding a column called Show_view_priv but something's wrong with the command.<div class="yiv352484704im"><br>
<br>
<br>
<blockquote class="yiv352484704gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
ERROR: 1050 Table 'plugin' already exists<br>
</blockquote></div>
Something's trying to create a table in the database called plugin, and it already exists.</blockquote><br>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?<br>
<br>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?<br>
<br>Cheers,<br>Steve<br></div>
</div><br>>> I have installed versio 5.1</div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363">>>I added skip-innodb to my.cnf then rebooted the pc.</div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363">>>There was no addition to the error log file, but mysql is still not running.</div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363">>> ps -aef |grep mysql does not show any mysql running.</div><div style="font-family: times new roman, new york, times,
serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_21_133854429561363">>>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. </div> </div> </blockquote></div> </div></body></html>