amslezak/mysqldump

Last active May 1, 2020 20:16

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/amslezak/94c404d0641de33e207c3eb3e89fb668.js"></script>
Save amslezak/94c404d0641de33e207c3eb3e89fb668 to your computer and use it in GitHub Desktop.

Download ZIP

dumps just structure. useful for rds dumps

Raw

/usr/local/mysql/bin/mysqldump --host=${hostname} --port=${port} --user=${dbuser} --password=${dbpass} --lock-tables=false --no-data --routines=true --verbose --set-gtid-purged=OFF --skip-tz-utc ${dbname} > ../dumps/AWS_${dbname}_${dt}.dump 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment