Skip to content

Instantly share code, notes, and snippets.

@boywhoroared

boywhoroared/mysql-dump-restore.sql

Created June 29, 2011 13:47
Show Gist options
  • Save boywhoroared/1053866 to your computer and use it in GitHub Desktop.
Save boywhoroared/1053866 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Dump & Restore Charset Safe
Raw
mysql-dump-restore.sql
mysqldump -u username -p --default-character-set=latin1 -N database > backup.sql
mysql -u username -p --default-character-set=latin1 database < backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment