migration of mysql to new server: wired errors

From: Julianony M <juliani.moon_at_gmail.com>
Date: Tue, 30 Jan 2018 13:55:59 -0800 (PST)
Message-ID: <285fb001-52f7-4f23-8a94-f73046e2a16e_at_googlegroups.com>

[Quoted] [Quoted] 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.

[Quoted] [Quoted] 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:
[Quoted] [Quoted]   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.

[Quoted] Thanks in advance!

j Received on Tue Jan 30 2018 - 22:55:59 CET