Skip to content

Instantly share code, notes, and snippets.

@lyonsun

lyonsun/command.sh

Last active August 29, 2015 14:01
Show Gist options
  • Save lyonsun/0177ab53b396cb43500a to your computer and use it in GitHub Desktop.
Save lyonsun/0177ab53b396cb43500a to your computer and use it in GitHub Desktop.
Download ZIP
export/import mysql database in command line.
Raw
command.sh
mysqldump -uUSERNAME -pPASSWORD -hHOSTNAME USER_DATABASE > FILENAME.sql
#Then import using:
mysql -uUSERNAME -pPASSWORD -hHOSTNAME USER_DATABASE < FILENAME.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment