I use this command to pull some remote db to local db:
$ ssh remote.com "mysqldump remotedb | gzip" | gzip -d | mysql localdb
I see this runs a bunch of individual commands on the database. Is there a faster way?
I will initiate the command from the local machine, and will be run by cron.
This methods leads to: Lost connection to MySQL server during query when dumping table