[codesyntax lang=”bash”]
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’
[/codesyntax]
Leave a Reply
You must be logged in to post a comment.