rossmckelvie

### 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