Skip to content

Instantly share code, notes, and snippets.

@douglascabral

douglascabral/clone-db-mysql.sh

Created April 2, 2018 13:45
Show Gist options
  • Save douglascabral/a2f2f11927e3146ec41a8e5a783b7e04 to your computer and use it in GitHub Desktop.
Save douglascabral/a2f2f11927e3146ec41a8e5a783b7e04 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clone-db-mysql.sh
mysqldump database_name_1 \
--host=address_1 \
--port=3306 \
--user=username_1 \
--password=password_1 \
--single-transaction \
--compress \
--no-create-db \
--skip-add-locks \
--skip-comments | mysql \
--host=address_2 \
--port=3306 \
--user=username_2 \
--password=password_2 database_name_2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment