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