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

mysql:12058

From: "safe" <"safe" <geohase@xxxxxxxxxx>>
Date: Fri, 2 Sep 2005 23:19:50 +0900
Subject: [mysql 12058] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï

Ω¾¾ÍÍ
¤´»ØƳ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¥×¥í¥Ð¥¤¥À¤«¤é¥À¥¦¥ó¥í¡¼¥É¤Ïgeohase.sql¤Çwindow¤Î¥Æ¥­¥¹¥È¥Õ¥¡¥¤¥ë
°ì¤Ä¤È¤Ê¤Ã¤Æ¤ª¤ê¡¢£±£°£°ÄøÅ٤Υơ¼¥Ö¥ë¤Î¹½Â¤¥Ç¡¼¥¿¤Èinsert¤Î¥Ç¡¼¥¿
¤¬75ʸ»úÌó£±£°£°£°£°¹Ô¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¾®À¸¤ÎÃμ±¤Ç¤Ï¡¢windows¤Î¥³¥Þ¥ó¥É¤«¤é°ì¤Ä°ì¤Ä¤Î¥Æ¡¼¥Ö¥ëºîÀ®¤Î
¥Ç¡¼¥¿¡¦insert¤Î¥Ç¡¼¥¿¤ò¥³¥Ô¡¼Å½¤êÉÕ¤±¤·¤ÆÆɤ߹þ¤Þ¤»¤ì¤Ð½ÐÍè¤ë¤Î
¤«¤Ê¤¡ÄøÅ٤Ǥ¹¡Ê¼ÁÌ䤵¤»¤Æ夤¤¿ÅÀ¤Ç¤ÏMySQL¤Ç¤ä¤ë¤Î¤Ç¤Ï¤Ê¤¯¡¢
Ê̤Υ½¥Õ¥È¤Ç¤â¤¢¤Ã¤Æ½ÐÍè¤ë¤Î¤«¤È»×¤Ã¤Æ¤¤¤Þ¤·¤¿¡Ë¡£

¥³¥Þ¥ó¥É¤«¤é¡¡mysql<geohase.sql¡¡¤ÏÀ®¸ù¤·¤Þ¤»¤ó¡ÊÉÔÌÀ¤Î¥³¥Þ¥ó¥É¤È
¥¨¥é¡¼¤¬Ìá¤ê¤Þ¤¹¡Ë¡£¡¡
µ¹¤·¤¯¤´»ØƳ²¼¤µ¤¤¡£¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Ç£Å£Ï£È£Á£Ó£Å

----- Original Message ----- 
From: "tatematsu" <tatemax@xxxxxxxxxx>
To: <ml@xxxxxxxxxx>
Sent: Friday, September 02, 2005 7:28 PM
Subject: [mysql 12057] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï


> ÄɲÃ
> Ω¾¾¤Ç¤¹¡£
> ¤Á¤ç¤Ã¤È°ÕÌ£ÉÔÌÀ¤Ê¤³¤È¤ò½ñ¤¤¤Æ¤¤¤¿¤Î¤Ç¾¯¤·Äɲá£
>
> ¥Ç¡¼¥¿¥Ù¡¼¥¹Ã±°Ì¤Çmysqldump¤·¤Æ¥À¥ó¥×¥Õ¥¡¥¤¥ë¤¬Â¿¤¹¤®¤ë¤Ã¤Æ
> ¤³¤È¤Ç¤·¤ç¤¦¤«¡©
>
> Á´¤Æ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò¤È¤Ã¤Æ¡Ê£±¥Õ¥¡¥¤¥ë¤È¤·¤Æ¡Ë
> mysqldump -F -q --add-drop-table --all-databases  > backup-all.sql
>
> ¥ê¥¹¥È¥¢¤¹¤ë
> mysql < backup-all.sql
>
> ¤Ç¤Ï¤À¤á¤Ç¤¹¤«¡£
>
> ¥×¥í¥Ð¥¤¥À¤Î¥µ¡¼¥Ð¤ÇphpMyAdmin¤Ê¤É¤Ç¥À¥ó¥×¤·¤¿¤â¤Î¤Ç¤âƱ¤¸ÊýË¡¤Ç¤¤
> ¤±¤ë¤«¤È»×¤¤¤Þ¤¹¡£
> ¤¿¤À¤·Ê¸»ú¥³¡¼¥É¤Ï¤É¤¦¤Ê¤ó¤Ç¤·¤ç¤¦¡©
> MySQL¤Î4.0·Ï¤È4.1·Ï¡¢5.0·Ï¤Ç¤Ï°ã¤¤¤¬¤¢¤ê¤Þ¤¹¤è¡£
> ¤¢¤È¡¢³°Éô¥­¡¼À©Ì󤬤¢¤ë¤È¥ê¥¹¥È¥¢»þ¤Ë¥¨¥é¡¼¤¬½Ð¤ë¤«¤â¤Ç¤¹¡£
> ¤½¤ó»þ¤Ï¡¢mysqldump¤¹¤ëÁ°¤Ë³°Éô¥­¡¼À©Ìó¤òºï½ü¤·¤Æ²¼¤µ¤¤¡£


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

     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]