mysqldump is also very useful for populating databases by copying data from one MySQL server to another:
shell> mysqldump —opt db_name | mysql —host=remote_host -C db_name
Через ssh
ssh -p 3333 -l root IP «mysqldump -u root -p»PASS» -ERA | gzip -3 -c» > allbases.sql.gz
