USE one option !

==================
–single-transaction
ex> mysqldump –user=root –password
                               –single-transaction    /*하나의 트랜잭션을 이용하여 Dump진행*/
                               –routines                        /*프로시저포함*/
                               –no-create-info           
/*테이블 생성스크립트 제외*/
                               –no-data
                        /*데이터 제외*/
                               –no-create-db             
/*DB 생성스크립트 제외*/
                              –triggers                        /*트리거백업*/
                                –skip-opt                     /*그룹옵션 실행 방지*/
                               [데이터베이스명]  >  `hostname`_`date ‘+%y%m%d’`.dump.sql

==================

Leave a Reply

Your email address will not be published. Required fields are marked *