Skip to content

Instantly share code, notes, and snippets.

@warnerpr
Created November 2, 2017 02:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save warnerpr/011cabb876600c33e5bee42d7d0b17d2 to your computer and use it in GitHub Desktop.
Save warnerpr/011cabb876600c33e5bee42d7d0b17d2 to your computer and use it in GitHub Desktop.
mysql dump run from the A0 host
mysqldump \
--host A0 \
--add-drop-table \
--add-drop-database \
-uroot \
-pXXXXXX \
--master-data \
--single-transaction \
--gtid --all-databases \
| mysql -uroot -pXXXXXX
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment