Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagebash
mysqldump  --single-transaction --databases db1 db2 -h localhost -u root -pmypwd > mydump.sql

db1만 백업하고 CREATE, USE 구문 미포함

Note

--databases 옵션 제외하면 USE 구문이 빠짐

Code Block
languagebash
mysqldump  --single-transaction db1 -h localhost -u root -pmypwd > mydump.sql

db1만 포함하고 db내 table1, table2만 제외

...