2009. 11. 3. 10:22
Project & studying/Undergraduate
- lock걸린 table 포함하여 백업
mysqldump -u[user] -p[password] --lock-all-tables [DBname] > [filename]
ex) mysqldump -uroot -p비번 --look-all-tables chromosomeDB > chromosomeDB.sql
- 복구
mysql -u[user] -p비번 [DB_NAME] < backup_file_name
