Skip to content

Instantly share code, notes, and snippets.

@srockstyle

srockstyle/table_backup.sql

Created March 12, 2013 22:29
Show Gist options
  • Save srockstyle/5147682 to your computer and use it in GitHub Desktop.
Save srockstyle/5147682 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
table_backup.sql
# データバックアップ(テーブル単位）
mysqldump -u ユーザ名 DB名 -p --default-character-set=binary --tables テーブル名 > backup.sql
# データのリストア（テーブル単位）
mysql -u ユーザ名 DB名 -p --default-character-set=binary < backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment