Skip to content

Instantly share code, notes, and snippets.

@jack2jm

jack2jm/Import - Export mySQL dump (aws RDS also))

Created July 5, 2021 09:45
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.
Download ZIP
Raw
Import - Export mySQL dump (aws RDS also))
**************** 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