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

  1. 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"
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2167"></script>

0 comment about "Copy a MySQL Database to a new Server via ssh with one command"