Code:
id10t@box:~/ $ mysqldump -u dbuser -p database | gzip -c > databasename.sql.gz
id10t@box:~/ $ scp databasename.sq.gz user@newhost:~/
id10t@box:~/ $ ssh -i .ssh/identity.pem user@newhost
user@newhost:~/ $ mysql -u root -p
Enter password:
mysql> create database devdb;
mysql> grant ALL on devdb to 'dbuser@localhost' identified by 'secretpassword';
mysql> quit
user@newhost:~/ $ mysql -u dbuser < zcat databasename.sql.gz
Makes me glad I didn't have the $$ for those MCSE classes back in '98....