Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
> Den 17. jul. 2019 kl. 11.48 skrev Erik Cederstrand : > > Thanks, Jocelyn! > >> Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier >> : >> It seems this table should be in InnoDB format, not MyISAM (same for >> innodb_table_stats). > > I tried altering the engine to InnoDB but was not allo

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
Thanks, Jocelyn! > Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier > : > It seems this table should be in InnoDB format, not MyISAM (same for > innodb_table_stats). I tried altering the engine to InnoDB but was not allowed. Hmm. Then I decided to just drop the table to have mysql_upgrade cr

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread jocelyn fournier
Le 17 juil. 2019 à 11:22, Erik Cederstrand a écrit : > > Thanks! > > I couldn't find the mysql_fix_privilege_tables.sql installed anywhere on my > system, so I ended up patching mysql_upgrade to print the SQL commands it's > executing. There are ca. 200 commands executed at once, so it took a

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
Thanks! I couldn't find the mysql_fix_privilege_tables.sql installed anywhere on my system, so I ended up patching mysql_upgrade to print the SQL commands it's executing. There are ca. 200 commands executed at once, so it took a while to pinpoint the failing statement. It would be cool if tripl