Posted
Filed under Mysql
1. --single-transaction 옵션 추가
mysqldump -u 유저 -p --single-transaction db_name > db.sql

출처 http://moondoin.tistory.com/


2.  --lock-all-tables 옵션 추가
mysqldump -u 유저 -p --lock-all-tables db_name > db.sql

출처 http://softm.net/files/database.html?id=mysql_tip&notice_id=&s=&tot=&search=&search_cond=&no=21&print_no=21&exec=view&npop=&sort=hit&desc=desc&search_cat_no=2


2008/12/14 13:08 2008/12/14 13:08
2009/07/17 20:36 2009/07/17 20:36