[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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]