poudelmadhav/backup.md

Last active February 3, 2025 07:20

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/poudelmadhav/b7e9bb89943d0f1b32db17d80d3f3627.js"></script>
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 --extended-insert --single-transaction --quick -h example.com -u username -p databasename > dump.sql --set-gtid-purged=OFF

With PV command:

mysqldump --no-tablespaces --extended-insert --single-transaction --quick -h example.com -u username -p databasename --set-gtid-purged=OFF | pv > dump.sql

Import it

mysql -h example.com -u username -p databasename < dump.sql

With PV command:

pv dump.sql | mysql -h example.com -u username -p databasename