Skip to content

Instantly share code, notes, and snippets.

@doniz

doniz/readme.md

Created August 3, 2018 17:18
Show Gist options
  • Save doniz/ac53b6dd0e503eec00094b5fa5f3e261 to your computer and use it in GitHub Desktop.
Save doniz/ac53b6dd0e503eec00094b5fa5f3e261 to your computer and use it in GitHub Desktop.
Download ZIP
migrate mysql database from host to host
Raw
readme.md

migrate mysql database from host to host

# migrate specific database
mysqldump -u root -proot -h192.168.91.100 --databases database_name | mysql
# migrate all database from the server
mysqldump -u root -proot -h192.168.91.100 --all-databases | mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment