I am trying to dump a database to an AWS-RDS instance from a local copy on EC2 instance.
sudo mysqldump –u <local_user> --databases world --single-transaction --compress --order-by-primary -p<local_password> | mysql –u <RDS_user_name> –-port=3306 --host=hostname –p<RDS_password>
However, I am only able to partially dump the database and get the following error:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table xxx at row: yyy
Every time, this error approximately occurs at the same row number. I think that this is due to some timeout parameter but not sure how to change it. Can someone help?
Aucun commentaire:
Enregistrer un commentaire