mysql, 백업 및 복원

# 데이터베이스 백업

$ mysqldump -u root -p --all-databases > all_databases.sql
$ mysqldump -u root -p -A > all_backup.sql$ mysqldump --opt -A -u root -ppassword > all_backup.sql
$ mysqldump -uID -p --default-character-set=latin1 DBNAME > DBNAME.sql$ mysqldump -uID -p DBNAME > DBNAME.sql

# 데이터베이스 복원

$ mysql -uroot -p

mysql> use DBNAME;
mysql> source DBNAME.sql
mysql> show tables;

# CVS파일로 복원

mysql> mysql -uroot -p
mysql> use dNb
mysql> load data infile '/var/www/html/disNbroad/db/frame_info.csv' into table frame_info fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';