Skip to content

Instantly share code, notes, and snippets.

@k12u

k12u/memo

Created December 21, 2011 13:50
Show Gist options
  • Save k12u/1506126 to your computer and use it in GitHub Desktop.
Save k12u/1506126 to your computer and use it in GitHub Desktop.
Download ZIP
partial mysqldump2
Raw
memo
# dbserver から new_serverへのコピー
$ mysqldump -t -n --compact -hdbserver -uuser_id \
db_name table_name -w 'row_id = 111' \
| mysql -hnew_server -uuser_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment