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

mysql:12069

From: tatematsu <tatematsu <tatemax@xxxxxxxxxx>>
Date: Sat, 03 Sep 2005 16:24:58 +0900
Subject: [mysql 12069] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï

Ω¾¾¤Ç¤¹¡£

mysql>¤Î¥×¥í¥ó¥×¥È¤Ç¡¢mysqlimport geohase C:\geohase.sql¤Ç¥Ç¡¼¥¿¤ò¥í¡¼¥É
¤·¤¿¤¤¤Î¤Ê¤émysqldump¤Ç¥Ç¡¼¥¿¤ò¼è¤ë¤Î¤Ç¤Ê¤¯¡¢SELECT INTO OUTFILE¤Ç¥¿¥Ö¶è
ÀÚ¤ê¤Î¥Õ¥¡¥¤¥ë¤ò¥¨¥¯¥¹¥Ý¡¼¥È¤·¤Ê¤¤¤È¤¤¤±¤Ê¤¤¤Î¤Ç¤Ï¡©

> ¥³¥Þ¥ó¥É¤«¤é¡¢mysql -u root -p ¤Ç¡¡EnterPassword¤È½Ð¤ÆPassword¤òÆþ¤ì¤ë¤È
> mysql>¤Î¥×¥í¥ó¥×¥È¤È¤Ê¤ê¤Þ¤¹¡£
¢¬
¤³¤ì¤¬¥À¥á¤Ê¤Î¤Ç¤Ï¡©mysql¥¯¥é¥¤¥¢¥ó¥È¤Î¥×¥í¥ó¥×¥È¤Ë¤Ê¤é¤º¤ËDOS¡Ê¡©¡Ë¤Î
shell¤«¤é°ìµ¤¤Ë
C:\> C:\mysql\bin\mysql -uroot -proot_password < C:\geohase.sql
C:\> C:\mysql\bin\mysql --user=root --password=root_password <
C:\geohase.sql¢«¤³¤Ã¤Á¤Î¤¬¤¤¤¤¤«¤â
¤Ç¤ä¤Ã¤Æ¤ß¤Æ²¼¤µ¤¤¡£
¡Êgeohase.sql¤òC:ľ²¼¤ËÃÖ¤¤¤Æ¤¢¤ë¤â¤Î¤È²¾Äꤷ¤Æ¤¤¤Þ¤¹¡£¡Ë

mysql¥¯¥é¥¤¥¢¥ó¥È¤ÎSQLʸ¤Ë"C:\geohase.sql"¤Ê¥³¥Þ¥ó¥É¤Ï̵¤¤¤Î¤Ç¥¨¥é¡¼
¤¬¤Ç¤ë¤ó¤¸¤ã¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
Windows¤Ï¤è¤¯ÃΤé¤Ê¤¯¤Æ¤ªÎϤˤʤ줺¤¹¤ß¤Þ¤»¤ó¡£


> > C:\> C:\mysql\bin\mysql -u YourName -p YourPassword < geohase.sql
> 
> ¥³¥Þ¥ó¥É¤«¤é¡¢mysql -u root -p ¤Ç¡¡EnterPassword¤È½Ð¤ÆPassword¤òÆþ¤ì¤ë¤È
> mysql>¤Î¥×¥í¥ó¥×¥È¤È¤Ê¤ê¤Þ¤¹¡£
> ¾åµ­¤Îgeohase.sql¤ÎÁ°¤Ï¥µ¡¼¥Ð¤ËÀܳ¤Î¼ê³¤­¤ÈƱ¤¸¤È»×¤¤¤Þ¤¹¤Î¤Ç¡¢Îà¿ä¤Ç
> mysql>¤Î¥×¥í¥ó¥×¥È¤Ç¡¢C:\geohase.sql¤È¤¹¤ë¤È¡ÉUnknown Command"¤Î¥¨¥é¡¼¤È
> ¤Ê¤ê¤Þ¤¹¡£
> ¤Þ¤¿¡¢mysqlimport¤Ï»È¤ï¤Ê¤¤¤È¤Î¤³¤È¤Ç¤¹¤¬¡¢
> mysql>¤Î¥×¥í¥ó¥×¥È¤Ç¡¢mysqlimport geohase C:\geohase.sql¡Ê¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤¬
> geohase¡Ë¤È¤¹¤ë¤È¡¢Syntax¤Î¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£
> 
> °Ê¾å¡¢¹¹¤Ë¥Ò¥ó¥ÈÅù¤ª´ê¤¤¤Ç¤­¤ì¤Ð¤È»×¤¤¤Þ¤¹¡£¡¡¡¡£Ç£Å£Ï£È£Á£Ó£ÅÇÒ
> 
> 
> 
> 
> 



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

     12055 2005-09-02 18:48 ["safe" <geohase@xxxx] SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï               
     12056 2005-09-02 19:08 ¨±[tatematsu <tatemax@x]                                       
     12057 2005-09-02 19:28 ¡¡¨±[tatematsu <tatemax@x]                                     
     12058 2005-09-02 23:19 ¡¡¡¡¨±["safe" <geohase@xxxx]                                   
     12059 2005-09-03 09:30 ¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                                 
     12061 2005-09-03 11:34 ¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                               
     12066 2005-09-03 12:26 ¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                             
     12067 2005-09-03 15:23 ¡¡¡¡¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                           
     12068 2005-09-03 16:11 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ]                         
->   12069 2005-09-03 16:24 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]