Thanks to a collegue of mine we were tasked with making a process to transfer files from one site to another in the event of a fail over. This happened to do the trick...
mysqldump -u root -pPASSWORD FS TABLE1 TABLE2 | ssh 'cat | mysql -u root -pPASSWORD FS'
Source: Timothy Boronczyk