[mysql] 백업

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