mysql:12109
From: Seiichi YANAI <Seiichi YANAI <yanai@xxxxxxxxxx>>
Date: Thu, 08 Sep 2005 10:32:55 +0900
Subject: [mysql 12109] Re: ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï
ÍÌ°æ¤È¿½¤·¤Þ¤¹¡£ safe ¤µ¤ó¤Ï½ñ¤¤Þ¤·¤¿: >¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤«¤éÄ̾ï¤Î¥³¥Ô¡¼¤ä¡¢MySQL ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾>¥Õ¥¡¥¤¥ë̾¤Ç >¥×¥í¥ó¥×¥È¤Ë¤Ê¤Ã¤Æ¡¢SQLʸ¤Îshow tables;¤ä¡¢Mysqldump¡¦Mysqlhotcopy >Åù¤ò¿§¡¹¤È»î¤¹¤Î¤Ç¤¹¤¬¡¢ËؤÉOutfile¤Ï¥À¥á¤È¤Î¥¨¥é¡¼¤¬½Ð¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ ñ½ã¤Ë°ìÍ÷¤À¤±¤òÆÀ¤é¤ì¤ì¤Ð¤¤¤¤¤Î¤Ç¤¢¤ì¤Ð¥á¥âÄ¢¤ÇSQLʸ¤ò½ñ¤¤¤¿¤â¤Î¤ò ºî¤Ã¤Æ¥ê¥À¥¤¥ì¥¯¥È¤ÇÅϤ·¤Æ¤ä¤ì¤Ð¤¤¤¤¤Ç¤·¤ç¤¦¡£ ¤¿¤È¤¨¤Ð¡¢test¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤¢¤ë¤È¤·¤Þ¤¹¡£ test.sql¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤ò°Ê²¼¤ÎÆâÍƤǺîÀ®¤·¤Þ¤¹¡£ use test; show tables; ¤³¤ì¤ò mysql -u ¥æ¡¼¥¶Ì¾ -p ¥Ñ¥¹¥ï¡¼¥É < test.sql >result.txt ¤ÇÅϤ·¤Æ¤ä¤ë¤È¥Æ¡¼¥Ö¥ë°ìÍ÷¤¬result.txt¤Ë½ñ¤½Ð¤µ¤ì¤Þ¤¹¡£ ¡ô ÍÌ°æ À¿°ì (Seiichi YANAI) ¡ô e-mail:yanai@xxxxxxxxxx ¡ô MySQL for OS/2 ...
12107 2005-09-08 10:04 ["safe" <geohase@xxxx] ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï 12108 2005-09-08 10:23 ¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] -> 12109 2005-09-08 10:32 ¨±[Seiichi YANAI <yanai] 12111 2005-09-08 15:32 ¡¡¨±["safe" <geohase@xxxx] 12113 2005-09-08 16:27 ¡¡¡¡¨²[Seiichi YANAI <yanai] 12118 2005-09-09 09:55 ¡¡¡¡¨¨±["safe" <geohase@xxxx] 12115 2005-09-08 16:39 ¡¡¡¡¨±[SUGIMURA Takashi ¿ùÂ] 12116 2005-09-08 17:24 ¡¡¡¡¡¡¨²[Seiichi YANAI <yanai] 12123 2005-09-09 11:29 ¡¡¡¡¡¡¨±["safe" <geohase@xxxx]