Avatar of rboudrie
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?


MySQL Server

Avatar of undefined
Last Comment
ygoutham
ASKER CERTIFIED SOLUTION
Avatar of Raynard7
Raynard7

Blurred text
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.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of ygoutham
ygoutham
Flag of India image

Blurred text
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 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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo