Copy Database From Remote Machine to RPi

mysqldump -h [source_db_server_ip_address] -u [source_db_username] -p[source_db_password] [source_db_database_name] | mysql -h localhost -u [dest_db_username] -p[dest_db_password] [dest_db_database_name]

For example:

mysqldump -h 1.2.3.4 -u admin1 -pabcd mydatabase | mysql -h localhost -u admin1 -pabcd mydatabase