Skip to content

Instantly share code, notes, and snippets.

@poudelmadhav

poudelmadhav/backup.md

Created March 19, 2024 12:09
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 poudelmadhav/b7e9bb89943d0f1b32db17d80d3f3627 to your computer and use it in GitHub Desktop.
Save poudelmadhav/b7e9bb89943d0f1b32db17d80d3f3627 to your computer and use it in GitHub Desktop.
Download ZIP
Export/Dump and import mysql data
Raw
backup.md

Dump MySQL data

mysqldump --no-tablespaces -h example.com -u username -p databasename > dump.sql --set-gtid-purged=OFF

Import it

mysql -h example.com -u username -p databasename < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment