任意のレコードだけ手作業で別のDBへ移したいときとかに。
$ mysqldump --opt -u root -p データベース名 テーブル名 "-w where id=1" > dump.sql
# CREATE TABLEを書き込まない場合は-t,–no-create-infoオプション
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme