Error ERROR 1153 (08S01) during mysqldump restoration on Amazon RDS
In order to change a dynamic option in Amazon RDS, you will have to modify the DB Parameter associated with the DB Instance.

Edit the option max_allowed_packet value, setting it to 1073741824.

Once you save it, it should be applied immediately since it is a dynamic option.

Afterwards, you can verify the change by logging into the RDS instance and running

SELECT @@global.max_allowed_packet;


Once verified, you may proceed to load your mysqldump.