Transfer a MySQL Dump to another server and install it.

Sep 11 2013 2:49 PM SEP 11 2013 2:49 PM
All in one line!MySQL | Unix | Ubuntu

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

Social Media

Categories