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]