Skip to content

Instantly share code, notes, and snippets.

@Big-Vi
Created February 28, 2023 21:33
Show Gist options
  • Save Big-Vi/382f80e1bcfa7d66c41a2cd38f19aa94 to your computer and use it in GitHub Desktop.
Save Big-Vi/382f80e1bcfa7d66c41a2cd38f19aa94 to your computer and use it in GitHub Desktop.
Download remote MySQL DB to local computer
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