Skip to content

Instantly share code, notes, and snippets.

@urbels

urbels/migratesql.txt

Created December 4, 2013 09:42
Show Gist options
  • Save urbels/7784905 to your computer and use it in GitHub Desktop.
Save urbels/7784905 to your computer and use it in GitHub Desktop.
Download ZIP
migrate mysql from one server to another with ssh
Raw
migratesql.txt
mysqldump -u root -pPASSWORD. --all-databases | ssh user@newhost.com 'cat - | mysql -u root -pPASSWORD'
after this run flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment