Slow loading mysql dump into RDS

It's the PIOPS, stupid. Try cranking them up, e.g. 300GB volume at 3000 IOPS on your RDS instance when you create it.

See if that helps.

I just went from load taking days to load taking only hours.

This is an official AWS collection point for data, so please leave a comment on your experience. jk.

mysqldump between two servers over ssh

1. set up ssh keys so server1 user can ssh to a server2
2. set $HOME/.my.cnf so both users can get into respective mysql cli without passwords
1. see below for sample file
3. create the new, empty database on server2, receiving server
4. from server1
1. mysqldump mydatabase | ssh server2 mysql mydatabase

Taken: http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html

# $HOME/.my.cnf

[client]

password=myusersmysqlpassword