Re: migration of mysql to new server: wired errors

On 30/01/18 21:55, Julianony M wrote:
> I have recently migrated several databases from MySQL-5.0.95 on a RedHat-6 server to MySQL-5.6.39 on a RedHat-7 server, along with their perl applications.
>
> While everything works just fine on the old server, it encounters problems on the new server when I perform the same database load:
>
> ERROR 1071 (42000) at line 383:
> Specified key was too long; max key length is 767 bytes
>
> although the same data, same scripts works just fine on the old server.
>
> Could anyone suggest possible causes or spots to look at for a fix? A simple comparisons of /etc/my.ini from the two servers didn't give me much clue.
>

Is this relevant?

https://stackoverflow.com/questions/40660396/sql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes

> Thanks in advance!
>
> j
>
>

-- 
Future generations will wonder in bemused amazement that the early 
twenty-first century’s developed world went into hysterical panic over a 
globally average temperature increase of a few tenths of a degree, and, 
on the basis of gross exaggerations of highly uncertain computer 
projections combined into implausible chains of inference, proceeded to 
contemplate a rollback of the industrial age.

Richard Lindzen