Skip to content

Instantly share code, notes, and snippets.

@FabienSalles
Created August 19, 2015 12:56
Show Gist options
  • Save FabienSalles/a283e7ebb9f743e9016f to your computer and use it in GitHub Desktop.
Save FabienSalles/a283e7ebb9f743e9016f to your computer and use it in GitHub Desktop.
Use Mysql dump
mysqldump -u root -p database > dump.sql
scp -P 22 root@host:dump.sql ./
pv sqlfile.sql | mysql -uxxx -pxxxx dbname
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment