본문 바로가기

MySQL

[MySQL] dump without transaction

1. DDL only

mysqldump -uneed4spd -p --skip-add-locks --single-transaction --skip-lock-tables -d DBNAME > /home/need4spd/test.sql


-> -D가 no data

2. no create info
mysqldump -uneed4spd -p --skip-add-locks --single-transaction --skip-lock-tables --no-create-info DBNAME > /home/need4spd/test.sql