Re: MySQL Platform Migration

[Ryan Coleman]

Right...

I don't like seeing people being shredded by a high strung personality because 
they simply don't understand things at your level, Reiny. 

Be nice to people and I won't say anything. Be an ass and I will. 

> On Sep 13, 2016, at 06:39, Reindl Harald <h.rei...@thelounge.net> wrote:
> 
> 
> 
>> Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
>> - Original Message -
>>> From: "Ryan Coleman" <ryan.cole...@cwis.biz>
>>> Subject: Re: MySQL Platform Migration
>>> 
>>> Because they want to be belittled by european jackasses online.
>> 
>> The thing is, while he has a bit of a rough edge, his technical advice is 
>> always solid. What has your contribution been, outside of insulting him, and 
>> for some reason, an entire continent?
> 
> this guy is just mentally ill and the next steps are:
> 
> * starting off-list mails (already happened)
> * can't stand the repsone
> * add a list-moderator to CC
> * setup something in his MUA which send all read messages back
>  to me (includig old ones from other lists he reads again)
> * can't stand the response to that action
> * forwards that responses to my boss
> * after having enough of the game and reject his
>  envelope asking for list-removal by pretending
>  that my server sends bounces to all his list mails while
>  in fact it only rejects private email
> 
> https://mail-archives.apache.org/mod_mbox/spamassassin-users/201608.mbox/%3cbb0c1584-f56a-4c1e-8b58-0d4b7d9a8...@cwis.biz%3E
> 
> 
> the reason for that personal hate (statet on a different list) is that 
> repsone from last year: https://marc.info/?l=mysql=144526386203911=4
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Ryan Coleman]

Dear sir,

You do not realize that there aren’t always sys admins on these lists. Your 
proven track record of asshole first, kid gloves later drives people away.

Your fight to change mailing lists is one which only you seem to share.

Goodnight. 

> On Sep 12, 2016, at 7:27 AM, Reindl Harald  wrote:
> 
> first: get rid of "reply-all"o n mailing-lists, you break others "reply-list" 
> button with the second copy which arrives usually faster the the list one
> 
> Am 12.09.2016 um 13:35 schrieb Harrie Robins:
>> It is bad practice to do so in my eyes (and yes that is an *opinion*).
>> When you advice people, instruct them to take the proven route, as
>> described in the mysql documentation
> 
> proven route?
> 
> proven is that you can *test* how it works out by
> * hot rsync
> * shut down the old server
> * cold rsync
> * start the old server
> which is scriptable to minimize downtime
> 
> after that (while the old machine is still in production) you figure out what 
> needs to get adopted in the configuration
> 
> then you test your software, prove that everything works fine
> 
> in the meantime you can test as often as you want the hot-cold-rsync to 
> refresh the mysql databases from production - and *now you have proven* that 
> everything works
> 
> since you have proven that successful you can write a final script which does 
> the sync (over ssh with certificates) a last time, restart the old servers 
> network servioce with a prepared network address and on the new server take 
> over the old ip adress
> 
> and trust me: that way you minimize downtime, have a proven *by yourself* way 
> to go which works, is tested and when correct done nobody notices that the 
> machine and undrlying operating system changed
> 
> after doing that dozens of times for thousands of mysql databases i know what 
> i am doing and call bad practice ways which take depending on database sizes 
> hours and beware god something goes wrong with your dump
> 
>> Second, mastering mysqldump should be golden standard for any DBA.
>> Telling someone that asks for guidance to simply copy around some files
>> is bad practice as you do not know the level of expertise involved.
> 
> the golden standard for any sysadmin is to know where his datafiles and 
> configuration files are stored and how they work together - independent of 
> the software type
> 
>> Regards,
>> Harrie
>> 
>> On 12 September 2016 at 11:03, Reindl Harald > > wrote:
>> 
>> 
>> 
>>Am 12.09.2016 um 10:48 schrieb Harrie Robins:
>> 
>>Ok let's drop this. Simply copying files to migrate a server is
>>not the
>>approach to take (in my humble opinion)
>> 
>> 
>>And why?
>> 
>>When you start with "Get the same release-version of mysql running
>>on the target platform" and dump/load what's the point in playing
>>around with dump-files when you hava binary datafiles which can be
>>used on the destination
>> 
>>and no - i am not talking about theory
>> 
>>i migrated a hosting-infrastructure with dozens of servers from OSX
>>PPC to OSX Intel and later to Linux x86_64 with just rsync the
>>mysql-datadir
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Ryan Coleman]

Because they want to be belittled by european jackasses online.

On Sep 10, 2016, at 11:56 PM, Reindl Harald  wrote:
> 
> 
> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal:
>> Is the mysql datafile compatible with different operation system ? I have 
>> not done this in the past.
> 
> why shouldn't it when the identical software is running?
> it's just a bunch of files used by mysql
> 
> as said copy it to the new machine and you are done - why do people these 
> days not just try out things, look if it works and when it don't asking 
> questions?
> 
>> - Original Message -
>> From: Reindl Harald 
>> To: mysql@lists.mysql.com
>> Sent: Saturday, September 10, 2016 7:19 PM
>> Subject: Re: MySQL Platform Migration
>> 
>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
>>> Is there any documentation for migrating mysql 5.0 database from darwin to 
>>> Linux
>> 
>> what do you need to migrate?
>> 
>> shutdown mysqld, copy the datadir to the new machine, start mysqld with
>> adopted configuration on the new machine - done
>> 
>> P.S:
>> don't cross-post on mysql and mariadb list
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: a

[Ryan Coleman]

You’re the one in grade school that always reminded us the teacher might be 
coming back soon and we should behave, right?


> On Oct 18, 2015, at 4:40 PM, Reindl Harald <h.rei...@thelounge.net> wrote:
> 
> what about stop that bullshit or at least purge the list after press 
> reply-all?
> 
> Am 18.10.2015 um 22:52 schrieb bluethu...@gmail.com:
>> e
>> 
>> Sent from my iPhone
>> 
>>> On Oct 18, 2015, at 4:12 PM, Daevid Vincent <dae...@daevid.com> wrote:
>>> 
>>> d
>>> 
>>>> -Original Message-
>>>> From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf
>>>> Of Ryan Escarez
>>>> Sent: Friday, October 16, 2015 2:47 AM
>>>> To: Ryan Coleman
>>>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
>>>> Subject: Re: a
>>>> 
>>>> c
>>>> 
>>>> On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman <ryan.cole...@cwis.biz>
>>>> wrote:
>>>> 
>>>>> b
>>>>> 
>>>>>> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz <darv...@gmail.com> wrote:
>>>>>> 
>>>>>> a
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: a

[Ryan Coleman]

b

> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz  wrote:
> 
> a
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Using Joins/Unions

[Ryan Coleman]

No but there should be. If there's not my task is useless. 

Secondly yes. Unique name on it too. 

--
Ryan Coleman
Publisher, d3photography.com
ryan.cole...@cwis.biz
m. 651.373.5015
o. 612.568.2749

 On Aug 4, 2015, at 17:33, Wm Mussatto mussa...@csz.com wrote:
 
 On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
 I have been a MySQL user and supporter for over a decade (since 2001) and
 I am almost ashamed to admit that I haven’t the faintest idea on how to do
 joins and unions.
 
 I have a specific query I would love to run…
 
 I have two tables, one with Unique data (“images”) and one with
 corresponding paths but many replicated records (“files”).
 
 I want to run a query that takes the results from /images/ and also
 searches /images.file/ as a LIKE statement from /files.path/, sort by
 /files.filesize/ in descending order returning just the first record
 (largest file size).  There may be up to 750 records from /images/ and
 thusly could be 3000+ from /files/.
 
 How on earth do I do this?
 
 —
 Ryan
 First question, will there always be at least one record in the files
 table for every record in the images table?  That controls the kind of
 join you will use.  I don't think that a union is a player. Also, is there
 a unique record ID in each of the table?
 --
 William R. Mussatto
 Systems Engineer
 http://www.csz.com
 909-920-9154
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Using Joins/Unions

[Ryan Coleman]

I have been a MySQL user and supporter for over a decade (since 2001) and I am 
almost ashamed to admit that I haven’t the faintest idea on how to do joins and 
unions.

I have a specific query I would love to run…

I have two tables, one with Unique data (“images”) and one with corresponding 
paths but many replicated records (“files”).

I want to run a query that takes the results from /images/ and also searches 
/images.file/ as a LIKE statement from /files.path/, sort by /files.filesize/ 
in descending order returning just the first record (largest file size).  There 
may be up to 750 records from /images/ and thusly could be 3000+ from /files/.

How on earth do I do this?

—
Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

MS Access and mySQL

[Jonathan Coleman]

Hi.

I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT.  They are (woohoo)
upgrading to a QUBE (linux box) for a server which has mySQL installed
(and I can upgrade it etc..)

My job therefore is to 

a) port MS Access data and queries to mySQL database

b) use the MS Access forms to access the data and queries through ODBC.

Is there anyone who can point me in the right direction, either to
where the searchable discussion archives are, OR even better, someone
who has gone through this before?

Cheers
Jon

http://digital.yahoo.com.au - Yahoo! Digital How To
- Get the best out of your PC!

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Internal Select statements using IN and NOT IN

[Alan Coleman]

I've noticed that MySQL doesn't support the use of internal selects with the
in and not in methods such as in this example from a where statement.

and shift_id not in
(select shift_assoc from facdba.staff_schedule_temp
where status  'EXL')

This functionality is available in Oracle but I'm trying to use a program I
wrote on a sever running MySQL.  I'm able to do everything else with some
changes to my sql statements, but I need the ability to do an internal
select on the fly in my sql statements so that I can compare a value from
one table to a list of results from another select.  In this particular
example, I do not have the ability to call the internal select first and
then insert it into the next database call.  It needs to be done on the fly
because unlike the simple example above, this call is very complex and
involves may variables and unioned selects.

 Joins don't work especially since I'm using the NOT IN clause.  I find it
really hard to believe that MySQL doesn't have support for this or some
other functionality to replace it.  I mean it has everything else and then
some.  But I've searched the documentation and haven't found anything.

If anyone knows a way to perform an internal select similar to what is shown
above, please let me know.
---
Alan Coleman
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Internal Select statements using IN and NOT IN

[Alan Coleman]

Never mind, I figured it out by reading a previous question and I understand
how to use Left join to do this.



-Original Message-
From: Alan Coleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:22 AM
To: [EMAIL PROTECTED]
Subject: Internal Select statements using IN and NOT IN



I've noticed that MySQL doesn't support the use of internal selects with the
in and not in methods such as in this example from a where statement.

and shift_id not in
(select shift_assoc from facdba.staff_schedule_temp
where status  'EXL')

This functionality is available in Oracle but I'm trying to use a program I
wrote on a sever running MySQL.  I'm able to do everything else with some
changes to my sql statements, but I need the ability to do an internal
select on the fly in my sql statements so that I can compare a value from
one table to a list of results from another select.  In this particular
example, I do not have the ability to call the internal select first and
then insert it into the next database call.  It needs to be done on the fly
because unlike the simple example above, this call is very complex and
involves may variables and unioned selects.

 Joins don't work especially since I'm using the NOT IN clause.  I find it
really hard to believe that MySQL doesn't have support for this or some
other functionality to replace it.  I mean it has everything else and then
some.  But I've searched the documentation and haven't found anything.

If anyone knows a way to perform an internal select similar to what is shown
above, please let me know.
---
Alan Coleman
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mySQL newbie?

[coleman]

Greetings

I teach beginning programming to High School students at Pasco High in
Pasco, WA.
I recently went to receive some training at the Oracle Internet Academy
in California and
found Oracle to be a big stretch for me and my students.
We've downloaded MySQL and the MySQL client.

We would like to run mySQL gui client and mySQl locally first then from
a server.
How do I access the mySQL database from mySQL gui.

Is their another gui I could use to populate a mySQL database?

Thank You,
Craig Coleman


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Install and testing problem?

[Patrick Coleman]

I have compiled and installed mysql 3.23.33 and now 3.23.36 on
a MAC OS X machine..

uanme -a gives..

Rhapsody haarp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; 
root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 
Apple Computer, Inc. All Rights Reserved.  Power Macintosh

With the .33 version everything seemed ok until one of our developers tried to
insert a BLOB into the database using WebObjects. He says he gets an error and 
all sort of strange ASCII characters? I saw someone suggest upgrading to at least
.34a to fix this. I have now upgraded to .36

We haven't tried the BLOB insert yet but I was running the mysql-test-run program and 
got the following results.
As you can see one test is skipped and another (binary) failed.

Does anyone have an idea what the problem could be?

Thanks.
Pat.
 First results.
./mysql-test-run 
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave Databases
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST USER   SYSTEM  ELAPSEDRESULT

alias 0.06 0.13 0.32   [ pass ]
alter_table   0.02 0.17 0.45   [ pass ]
analyse   0.03 0.15 0.27   [ pass ]
auto_increment0.03 0.16 0.46   [ pass ]
backup0.01 0.18 0.39   [ pass ]
bdb-crash 0.05 0.15 0.24   [ pass ]
bdb        [ skipped ]
bigint0.04 0.15 0.27   [ pass ]
binary     [ fail ]

lt-mysqltest: At line 34: Result length mismatch real 0.29 user 0.05 
sys  0.14 
Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

can't convert to db encoding

[Ian Coleman]

Hi
I have a WebObjects Application that I was using with
openbase and when I switched over to MySQL the app. could no
longer save the blob to the db.  Is there some way to save a
picture in a blob in binary or should I be doing it another way.

thank
Ian 

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php