mysqlhotcopy\ub294 mysql \ud328\ud0a4\uc9c0\uc5d0 \ud3ec\ud568\ub41c \uba85\ub839\uc5b4\ub85c, perl\ub85c \uc791\uc131\ub41c \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8 \uc774\ub2e4.<\/p>\n
mysql \ubc31\uc5c5 \ubc29\ubc95\uc911 \uac00\uc7a5 \uc18d\ub3c4\uac00 \ube60\ub974\uba70, OS \ud130\ubbf8\ub110\ucc3d\uc5d0\uc11c mysqlhotcopy \uba85\ub839\uc744 \ud1b5\ud574\uc11c DB \ub514\ub809\ud1a0\ub9ac\ub97c \uadf8\ub300\ub85c \ub2e4\ub978 \uc704\uce58\uc5d0 copy \ud55c\ub2e4.<\/p>\n
mysql\uc758 \uc5ec\ub7ec\uac00\uc9c0 engine type \uc911 MyIsam \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\ub9cc \uac00\ub2a5\ud55c \ub2e8\uc810\uc774 \uc788\ub2e4.<\/p>\n
1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5<\/p>\n
– \uc0ac\uc6a9\ubc95 : mysqlhotcopy [db_name] [\ub514\ub809\ud1a0\ub9ac\uacbd\ub85c]<\/p>\n
\ubc31\uc5c5\ud560 DB\ub97c \uadf8\ub300\ub85c \ud574\ub2f9 \uacbd\ub85c\uc5d0 \ub514\ub809\ud1a0\ub9ac\ub85c \uc0dd\uc131\ud558\uc5ec \ubcf5\uc0ac\ud55c\ub2e4.<\/p>\n
mysql root \ud328\uc2a4\uc6cc\ub4dc\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\ub294 \uc544\ub798\uc640 \uac19\uc774 –password=[db_password] \ub610\ub294 -p [db_password] \uc635\uc158\uc744 \ucd94\uac00\ud574\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy mysql \/home\/jook\/mysqlbak<\/p>\n
DBI connect(‘;host=localhost;mysql_read_default_group=mysqlhotcopy’,”,…) failed: Access denied for user ‘root’@’localhost’ (using password: NO) at .\/mysqlhotcopy line 197<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy –password=XXXX mysql \/home\/jook\/mysqlbak<\/p>\n
Flushed 22 tables with read lock (`mysql`.`columns_priv`, `mysql`.`db`, `mysql`.`event`, `mysql`.`func`, `mysql`.`help_category`, `mysql`.`help_keyword`, `mysql`.`help_relation`, `mysql`.`help_topic`, `mysql`.`host`, `mysql`.`ndb_binlog_index`, `mysql`.`plugin`, `mysql`.`proc`, `mysql`.`procs_priv`, `mysql`.`proxies_priv`, `mysql`.`servers`, `mysql`.`tables_priv`, `mysql`.`time_zone`, `mysql`.`time_zone_leap_second`, `mysql`.`time_zone_name`, `mysql`.`time_zone_transition`, `mysql`.`time_zone_transition_type`, `mysql`.`user`) in 0 seconds.<\/p>\n
Locked 0 views () in 0 seconds.<\/p>\n
Copying 73 files…<\/p>\n
Copying indices for 0 files…<\/p>\n
Unlocked tables.<\/p>\n
mysqlhotcopy copied 22 tables (73 files) in 0 seconds (0 seconds overall).<\/p>\n
[root@localhost bin]#<\/p>\n
2. \uc99d\ubd84 \ubc31\uc5c5<\/p>\n
– \uae30\uc874\uc5d0 \ubc31\uc5c5\ub41c \ub514\ub809\ud1a0\ub9ac\uac00 \uc874\uc7ac\ud560 \uacbd\uc6b0\ub294 \uc544\ub798\uc640 \uac19\uc774 –allowold \uc635\uc158\uc774\ub098 –addtodest \uc635\uc158\uc744 \ucd94\uac00\ud574\uc11c \ubc31\uc5c5\ud55c\ub2e4.<\/p>\n
\ub450\uac00\uc9c0 \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\ub294 \uae30\uc874\uc5d0 \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \uc218\uc815\ub41c \ubd80\ubd84\ub9cc \uc5c5\ub370\uc774\ud2b8 \ub41c\ub2e4.<\/p>\n
–allowold \uc635\uc158\uc758 \uacbd\uc6b0, \uba54\ub274\uc5bc \uc0c1\uc73c\ub85c\ub294 \uae30\uc874 \ub514\ub809\ud1a0\ub9ac\uc758 \uc774\ub984\uc744 _old\ub97c \ubd99\uc5ec\uc11c \ubcc0\uacbd\ud55c\ub2e4\uace0 \ub418\uc5b4 \uc788\uc73c\ub098, \ud14c\uc2a4\ud2b8 \ud55c \ubc84\uc804\uc5d0\uc11c\ub294 _old \ub514\ub809\ud1a0\ub9ac\uac00 \uc0dd\uc131\ub418\uc9c0 \uc54a\uace0 –addtodest\uc640 \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ub098\uc654\ub2e4.<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy –password=XXX mysql \/home\/jook\/mysqlbak<\/p>\n
Can’t hotcopy to ‘\/home\/jook\/mysqlbak\/mysql’ because directory<\/p>\n
already exist and the –allowold or –addtodest options were not given.<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy –allowold –password=XXX mysql \/home\/jook\/mysqlbak<\/p>\n
Existing hotcopy directory renamed to ‘\/home\/jook\/mysqlbak\/mysql_old’<\/p>\n
Flushed 22 tables with read lock (`mysql`.`columns_priv`, `mysql`.`db`, `mysql`.`event`, `mysql`.`func`, `mysql`.`help_category`, `mysql`.`help_keyword`, `mysql`.`help_relation`, `mysql`.`help_topic`, `mysql`.`host`, `mysql`.`ndb_binlog_index`, `mysql`.`plugin`, `mysql`.`proc`, `mysql`.`procs_priv`, `mysql`.`proxies_priv`, `mysql`.`servers`, `mysql`.`tables_priv`, `mysql`.`time_zone`, `mysql`.`time_zone_leap_second`, `mysql`.`time_zone_name`, `mysql`.`time_zone_transition`, `mysql`.`time_zone_transition_type`, `mysql`.`user`) in 0 seconds.<\/p>\n
Locked 0 views () in 0 seconds.<\/p>\n
Copying 73 files…<\/p>\n
Copying indices for 0 files…<\/p>\n
Unlocked tables.<\/p>\n
mysqlhotcopy copied 22 tables (73 files) in 0 seconds (0 seconds overall).<\/p>\n
[root@localhost bin]#<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy –addtodest –password=XXX mysql \/home\/jook\/mysqlbak<\/p>\n
Flushed 22 tables with read lock (`mysql`.`columns_priv`, `mysql`.`db`, `mysql`.`event`, `mysql`.`func`, `mysql`.`help_category`, `mysql`.`help_keyword`, `mysql`.`help_relation`, `mysql`.`help_topic`, `mysql`.`host`, `mysql`.`ndb_binlog_index`, `mysql`.`plugin`, `mysql`.`proc`, `mysql`.`procs_priv`, `mysql`.`proxies_priv`, `mysql`.`servers`, `mysql`.`tables_priv`, `mysql`.`time_zone`, `mysql`.`time_zone_leap_second`, `mysql`.`time_zone_name`, `mysql`.`time_zone_transition`, `mysql`.`time_zone_transition_type`, `mysql`.`user`) in 0 seconds.<\/p>\n
Locked 0 views () in 0 seconds.<\/p>\n
Copying 73 files…<\/p>\n
Copying indices for 0 files…<\/p>\n
Unlocked tables.<\/p>\n
mysqlhotcopy copied 22 tables (73 files) in 0 seconds (0 seconds overall).<\/p>\n
[root@localhost bin]#<\/p>\n
3. \ud14c\uc774\ube14 \ubc31\uc5c5<\/p>\n
– \uc0ac\uc6a9\ubc95 : mysqlhotcopy [db_name.\/table_name\/] [\ub514\ub809\ud1a0\ub9ac\uacbd\ub85c]<\/p>\n
\ubc31\uc5c5\ud560 \ud14c\uc774\ube14\uc744 “DB\uba85.\/\ud14c\uc774\ube14\uba85\/” \uc73c\ub85c \uc785\ub825\uc744 \ud558\uace0 mysqlhotcopy\uba85\ub839\uc744 \uc2e4\ud589\ud558\uace0, \ubc31\uc5c5 \ub514\ub809\ud1a0\ub9ac\uc5d0\ub294 \ud574\ub2f9 \ud14c\uc774\ube14\ub9cc \ubc31\uc5c5 \ub41c\ub2e4.<\/p>\n
[root@localhost bin]# .\/mysqlhotcopy –password=XXX mysql.\/user\/ \/home\/jook\/mysqlbak\/<\/p>\n
Flushed 1 tables with read lock (`mysql`.`user`) in 0 seconds.<\/p>\n
Locked 0 views () in 0 seconds.<\/p>\n
Copying 3 files…<\/p>\n
Copying indices for 0 files…<\/p>\n
Unlocked tables.<\/p>\n
mysqlhotcopy copied 1 tables (3 files) in 0 seconds (0 seconds overall).<\/p>\n
[root@localhost bin]# cd \/home\/jook\/mysqlbak\/mysql<\/p>\n
[root@localhost mysql]# ls<\/p>\n
user.MYD \u00a0user.MYI \u00a0user.frm<\/p>\n
[root@localhost mysql]#<\/p>\n","protected":false},"excerpt":{"rendered":"
mysqlhotcopy\ub294 mysql \ud328\ud0a4\uc9c0\uc5d0 \ud3ec\ud568\ub41c \uba85\ub839\uc5b4\ub85c, perl\ub85c \uc791\uc131\ub41c \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8 \uc774\ub2e4. mysql \ubc31\uc5c5 \ubc29\ubc95\uc911 \uac00\uc7a5 \uc18d\ub3c4\uac00 \ube60\ub974\uba70, OS \ud130\ubbf8\ub110\ucc3d\uc5d0\uc11c mysqlhotcopy \uba85\ub839\uc744<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/263"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=263"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/263\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}