Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-23 Thread shawn l.green
(please do not top post - see my answer below) On 2/13/2018 4:00 PM, Machiel Richards wrote: ok, so we have managed to get an id out of the errors etc... however when we look in the table that id does not even exist at all. no idea what is going on here though.

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

2018-02-23 Thread Bob Eby
Subject: Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today > 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. > How do I run mysql_upgrade if the mysqld server won't start? Please don't bother to answer, I

mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

2018-02-23 Thread Bob Eby
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. How do I run mysql_upgrade if the mysqld server won't start? Man how stupid am I? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

2018-02-23 Thread Reindl Harald
Am 23.02.2018 um 15:15 schrieb Bob Eby: 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. How do I run mysql_upgrade if the mysqld server won't start? post the *full* errorlog and watch for invaluid config stuff most