CODEWITHSUNDEEP
mysql
tim4dev
tim4dev

Reputation: 2987

server mysql v3 , mysqldump v5 on remote

mysqldump (v5) generates an error:

mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE='MYSQL323' */': You have an error in your SQL syntax near '40100 SET @@SQL_MODE='MYSQL323' */' at line 1 (1064)

or

mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE='' */': You have an error in your SQL syntax near '40100 SET @@SQL_MODE='' */' at line 1 (1064)

How to make a dump of the database remotely?

Upvotes: 0

Views: 387

Answers (1)

stivlo
stivlo

Reputation: 85526

MySQL version 3.22 is a very old MySQL and the syntax is quite different. I think you'll need to install a mysqldump of the same version to succeed. If possible, then, consider upgrading.

Upvotes: 1

Related Questions