Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save jack2jm/c11651d61ae120acf611d1392c5396e6 to your computer and use it in GitHub Desktop.
Save jack2jm/c11651d61ae120acf611d1392c5396e6 to your computer and use it in GitHub Desktop.
**************** To export db from RDS ***********
mysqldump -h rds.host.name -u remote_user_name -p remote_db --set-gtid-purged=OFF > remote_db.sql
//add *****set gtid purged off**** - AWS RDS create problem if not added.
When prompted for password, provide the password
***************** To import db on RDS *******************
mysql -h rds.host.name -u remote_user_name -p remote_db < remote_db.sql
When prompted for password, provide the password
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment