Big-Vi/mysqldump.txt

Created February 28, 2023 21:33

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/Big-Vi/382f80e1bcfa7d66c41a2cd38f19aa94.js"></script>
Save Big-Vi/382f80e1bcfa7d66c41a2cd38f19aa94 to your computer and use it in GitHub Desktop.

Download ZIP

Download remote MySQL DB to local computer

Raw

mysqldump.txt

	mysqldump -u <username> -p <database> --no-tablespaces > <db-name>.sql
	scp -i <ssh-key-path> username@IP:<db-name>.sql <local-directory>

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