samedi 22 août 2015

AWS RDS dumping sql file results in Lost connection error

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