Skip to content

Instantly share code, notes, and snippets.

@vishnuhd

vishnuhd/readme.md

Created April 22, 2020 10:28
Show Gist options
  • Save vishnuhd/5fa3c5a7d7d2b00a6872304c8ad0d81c to your computer and use it in GitHub Desktop.
Save vishnuhd/5fa3c5a7d7d2b00a6872304c8ad0d81c to your computer and use it in GitHub Desktop.
Download ZIP
Export and Import mysql db
Raw
readme.md

Export

mysqldump --column-statistics=0 -h hostname -u root -p dbname > backup.sql

Import

mysql -h hostname -u root -p dbname < backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment