Skip to content

Instantly share code, notes, and snippets.

@tricker

tricker/gist:1323552

Created October 28, 2011 21:03
Show Gist options
  • Save tricker/1323552 to your computer and use it in GitHub Desktop.
Save tricker/1323552 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
# export data to file
mysqldump -uroot -ppassword hornet > hornet-dump.sql
# Drop database schema
mysqladmin -uroot -ppassword –f drop hornet
# create empty database schema
mysqladmin –uroot –ppassword create hornet
# push dump file into new database schema
mysql -uroot -ppassword hornet < hornet-dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment