rboudrie
asked on
Mysqldump 4.1 on a .23 database
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?
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
MySQL Server
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
49K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
