开发者

server mysql v3 , mysqldump v5 on remote

开发者 https://www.devze.com 2023-04-03 05:35 出处:网络
Main server with mysql 3.22.20a mysqldump (mysql v.5) on remote server mysqldump (v5) generates an error:
  • Main server with mysql 3.22.20a
  • mysqldump (mysql v.5) on remote server

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开发者_StackOverflow中文版)

How to make a dump of the database remotely?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消