|
|
mysqldump´Â È¿À²ÀûÀ¸·Î µ¥ÀÌÅ͸¦ ¹é¾÷ÇÏ´Â ¹æ½ÄÀÌ´Ù. ÀϹÝÀûÀ¸·Î Àüü ¹é¾÷À»ÇÏ¿© »ç¿ëÇϴµ¥ °¡²û ¸î ¸î °¡Áö »óȲÀÌÀÖ¾î ÀÌ·¸°Ô Á¤¸®ÇÑ´Ù. [ µ¥ÀÌÅÍ º£À̽º Àüü ¹é¾÷ - Àüü Å×À̺í°ú Insert¹®ÀÌ ±æ~~°Ô ¹é¾÷µÊ] $ mysql -u[username] -p[passwd] database_name > database_name.sql [ ƯÁ¤ Å×ÀÌºí ¹é¾÷ - ƯÁ¤ Å×À̺í°ú Insert¹®ÀÌ ±æ~~°Ô ¹é¾÷µÊ] $ mysql -u[username] -p[passwd] database_name table_name > table_name.sql [ ¶óÀκ° Insert¹®À¸·Î ¹é¾÷ ] $ mysqldump -u[username] -p[passwd] --extended-insert=false database_name table_name > table_name.sql [ ½ºÅ°¸¶ ¸¸ ¹é¾÷ ] $ mysql -u[username] -p[passwd] database_name -d table_name > table_name.sql [ µ¥ÀÌÅÍ ¸¸ ¹é¾÷ - µ¥ÀÌÅÍ°¡ Insert¹®ÀÌ ±æ~~°Ô ¹é¾÷µÊ] $ mysql -u[username] -p[passwd] database_name -t table_name > table_name.sql [ µ¥ÀÌÅÍ µ¥ÀÌÅÍ ¹®Àڼ ÁöÁ¤] $ mysql -u[username] -p[passwd] --default-character-set=utf8 database_name > database_name.sql |