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 di
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 unsubscr
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better.
Good luck,
Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
> If the return value of the UPDATE stmt is zero, the following stmt is ran:
By return value I assume you mean "rows affected" ?
> This is working great, and has been for many years; however,
> today I noticed it was not working on a particular MySQL server.
By "not working" what exactly is the
> if you define a column with any name and a type of
>
> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks Lucio,
This is much better advice than the NOW() built-in function I would
have suggested.
Kind Regards,
-Bob
--
MySQL General Mailing List
For list archives
First, have you tried GROUP_CONCAT(DISTINCT types) ?
Second I see my counts rise just as my group_concat() terms when I do
something similar to what you're talking about. Also, here:
val c_types d_types
3t9,t9,t9 a2,a3,a9
Your column headers don't seem to match your query.
Cameron,
Did you run the recommended configuration script manually?
mysql_install_db
This is run once after install to put the "stuff" in your datadir= location
which I pointed out may be missing (and was "empty" upon your inspection).
Thanks,
Robert
Hi "Learner",
You might want to try reading about SQL JOIN and/or CLIENT_MULTI_STATEMENTS.
Using databases is all about conglomerating results, but it helps to know
the environment first.
Hi Cameron,
I've seen a similar error running on windows 7.
When you look in your datadir= specified in my.ini what is there exactly
(hopefully not empty)? Do you have a mysql folder containing plugin.*
files at this location? (say .MYI etc)
It sounds like your data folders were either not copi
Wouldn't you run mysql_upgrade *before* upgrading? (ie: copy new stuff
onto old DB, *then* mysql_upgrade *then* start running new software?)
So I went to google, and realised that I’d probably upgraded without
> running mysql_upgrade. So I try..
>
> [~] john@server% (872) mysql_upgrade -u root -
> CONNECTION = 'mysql://root:root@*stripped*:3306/Prelude_copy/test001';
Should be more like:
CONNECTION = 'mysql://root:stripped_password@localhost/penrepository/test001';
Just seems word if you're showing us your password is root but not host...
I ran your example just fine against localhost
delete b from icd9x10 a
join icd9x10 b on a.icd9 = b.icd9 and a.id < b.id
>...
> CREATE TABLE `ICD9X10` (
> ...
> id icd9 icd10
> 25 29182 F10182
> 26 29182 F10282
> ...
Good luck,
Bob
12 matches
Mail list logo