View: Copy a MySQL Database to a new Server via ssh with one command

1. Copy a MySQL Database to a new Server via ssh with one command
   5 years ago by spirit
   1. mysqldump –add-drop-table –extended-insert –force –log-error=error.log -uUSER -pPASS OLD_DB_NAME | ssh -C user@newhost "mysql -uUSER -pPASS NEW_DB_NAME"
   bashmydsldumpmysqlshellssh
   Embed | View source
   Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2167"></script>