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 di

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 unsubscr

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

2015-08-12 Thread Bob Eby
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

Re: Sequence Numbering

2015-06-30 Thread Bob Eby
> 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

Re: get row inserted time or modified time

2015-06-09 Thread Bob Eby
> 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

Re: Why does a group_concat on a join change aggregate values?

2015-05-07 Thread Bob Eby
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.

Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0

2015-02-19 Thread Bob Eby
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

Re: Merging multiple SQL requests

2015-02-17 Thread Bob Eby
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.

Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0

2015-02-12 Thread Bob Eby
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

Re: mysql Digest 15 Aug 2014 12:32:06 -0000 Issue 5209

2014-08-18 Thread Bob Eby
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 -

RE: Unable to connect to foreign data source

2014-03-31 Thread Bob Eby
> 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

Re: Help with cleaning up data

2014-03-31 Thread Bob Eby
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