将数据库从服务器复制到其他服务器时发生mysqldump错误

irlmq6kh 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(378)

我正试图像这样把数据库从一台服务器复制到另一台服务器

mysqldump -u<source_db_username> -p<source_db_password> -h<source_db_ip_address> source_database_name
| mysql -u<target_db_username> -p<target_db_password> -h<aws_rds_endpoint> <aws_rds_db_name>;

但我明白了

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server 
version for the right syntax to use near 'mysqldump -u<source_db_username> -p<source_db_password> 
-h<source_db_ip_address> source_database_name ' at line 1

mysql

来源：https://stackoverflow.com/questions/50434336/mysqldump-error-while-copying-database-from-server-to-another