We are in the process of converting a MySQL-using application from one system (the "source") to another (the "target"). The application is simply to load a mysqldump file into a database and do some sanity checking on it. The mysqldump is created from a database that supports a postfix application; however, this "should not" be significant.
The "source" machine has been in production use for years.
The versions of MySQL on the two machines are as follows:
source: mysql-server-5.0.90_2 Multithreaded SQL database (server)
target: Distrib 5.1.57, for apple-darwin10.7.0
We have run into a couple of issues. The primary issue at this point is shown by the following error message which we are getting on the target machine, but never had on the source machine.
This error message is strange for the following two reasons:
1. It does not occur on the source machine.
2. There should not be keys anywhere near that length in any case.
So I am wondering what is going on.