Skip to content

Instantly share code, notes, and snippets.

@rossmckelvie

rossmckelvie/mysql_xfer.sh

Last active October 9, 2016 02:26
Show Gist options
  • Save rossmckelvie/18ed7c2401eb6fcefbcd31ff18e76ac3 to your computer and use it in GitHub Desktop.
Save rossmckelvie/18ed7c2401eb6fcefbcd31ff18e76ac3 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Migrate databases & users to new server
Raw
mysql_xfer.sh
### Transfer databases ###
mysqldump -h oldhost.com -P 3306 -u dbuser -p --databases api_db other_db etc_db > all.sql
mysql -h newhost.com -u dbuser -p < all.sql
### Transfer users & privileges ###
# http://serverfault.com/a/13050 save to grants.sql
# Remove any users you don't want to copy over (root user, rdsrepladmin, etc.)
mysqldump -h newhost.com -P 3306 -u dbuser -p < grants.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment