프로그래밍/MySQL

[mysql] 백업

선제 2012. 1. 31. 10:09

bold체 : 유저지정


1. 특정 DB backup
  • mysqldump -u account -p password database_name > filename.sql 
     
2. 모든 DB backup
  • mysqldump -u account -p  password -A > filename.sql
     
3. 선택적 DB backup
  • mysqldump -u account -p password --databases database_name1
    database_name2     > filename.sql
4. 특정 table backup
  • mysqldump -u account  -p password database_name table_name > filename.sql
     
5. backup file recovery
  • mysql -u account  -p passowrd database_name < filename.sql