MySQL commands useful for data transfer

mysql yourdatabase --user=youruser --password=yourpassword --default_character_set=utf8 < yourdata.sql

mysqldump db1 --user=yourusername --password=yourpassword | mysql db2 --user=yourusername --password=yourpassword2