ó : http://comnic.tistory.com/39
MySQL ϴ ũ ΰ з ִ.1. mysqldump ̿ textŸ .2. ü ϴ .ΰ Ƿ 뵵 ʿ信 ° ϴ .1. mysqldump ̿ (ó : http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html)
mysqldump Igor Romanenko α̴. ̴ database database Ϻθ ϴ ̳ ٸ ý ű涧 ȴ. ϴ и ڸ ־ CSV , XML ִ. ɼǵ ϰ ִ ŭ ϴ 뵵 ̴. ⺻ ˾ . Ʒ ɼǥ ÷ ̴.1) database
shell> mysqldump -u user -p db_name > ϸ
shell> mysqldump -u comnic -p database1 > database1_20090321000000.sql
comnic̶ database1̶ database database1_20090321000000.sqlϷ ϶ ̴.2) table
shell> mysqldump -u user -p db_name table_name > ϸ
shell> mysqldump -u comnic -p database1 table1 > table1_20090321000000.sql
comnic̶ database1 table1̶ table table1_20090321000000.sqlϷ ϶ ̴.3) Table
shell> mysqldump --no-data -u user -p db_name > ϸ
shell> mysqldump --no-data -u comnic -p database1 > 20090321000000.sql
comnic̶ database1 table 20090321000000.sqlϷ ϶ ̴.--no-data ɼ create table常 ϱ⸦ Ҷ Ѵ.4) Table
shell> mysqldump -u user -p --tab=Path db_name
shell> mysqldump -u comnic -p --tab=/backup database1
/backup̶ table tbl_name.sqlϰ tbl_name.txt Ѵ. ̴ Table и Ͽ ϴ ǹ Ѵ. .sql .txt Ѵ. ̶ и ڰ Ǵµ ⺻ tab ȴ. иڸ ϸ ϴ и ڷ ִ.5) CSVϷ ٸ и ڷ
shell> mysqldump -u user -p --tab=Path --fields-terminated-by='и' db_name
shell> mysqldump -u comnic -p --tab=/backup --fields-terminated-by=',' database1
⺻ и tab , Ѵ. , CSVϷ ȴ. 6) XML
shell> mysqldump -u user -p --xml db_name > ϸ
shell> mysqldump -u comnic -p --xml database1 > 20090321000000.xml
2. ϱ
ϴ Ʒ .
shell> mysql -u user -p db_name < ϸ
shell> mysql -u comnic -p database1 < 20090321000000.sql
ѱ 찡 ִ. Ʒ --default-character-set ɼ Ѵ.
shell> mysql -u user -p --default-character-set=euckr db_name < ϸ
3. ̳ʸ ( Ȥ ̿)
MySQL ϴ ڵ data ϴ ٰ Ѵ. ϰ ִ. shell α ڵ ٸ ý ftp ̿ ű ڵȭ ϰ ִ. shell ̿ ڵȭ κ ٷ絵 ϰڴ.1) ̿
cp tar ̿ϸ ִ. lock ɾְ 簡 unlock ־ Ѵ. ׳ ٽ ָ ȴ. ű ̶ ߰ ٽ ߰ ־ Ѵ.2) mysqlhotcopy ̿ (ó:http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy.html)
DBü Ҷ mysqldump ̸ ̿ϸ ִٰ Ѵ.mysqlhotcopy LOCK TABLES, FLUSH TABLES cp scp ̿ Ѵ. MyISAM
ARCHIVE
table ϴٴ ̴. .
shell> mysqlhotcopy db_name [/path/to/new_directory]
shell> mysqlhotcopy db_name_1 ... db_name_n /path/to/new_directory
Խ ̿ϴ ִ.
shell> mysqlhotcopy db_name./regex/shell> mysqlhotcopy db_name./~regex/