I have a system with MySQL 4.1.2 installed, and wish to do a dump of another system which is running mysql 3.23.41 (I don't have control over this second server, so upgrading is not an option).
When I run "mysqldump databasename -uusername -ppassword -hdomainname.com
I get the message:
mysqldump: mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE='MYSQL323' */': Query was empty (1065)
It looks as if MySqlk 3.2 can';s understand the comments sent over by MySqldump.
Short of installing Mysql 3.32, is there a way I can get MySqldump 4.1.2 working on a 3.23 database?