Sep 132012
 
mysqldump –opt –add-drop-table -Q -u localuser –password=localpassword localdatabase | pigz -c | ssh -c blowfish remoteuser@remoteserver ‘gunzip -c | mysql -u remoteuser –password=remotepassword remotedatabase’

This site uses Akismet to reduce spam. Learn how your comment data is processed.