Ω¾¾ÍÍ
¤´»ØƳ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¥×¥í¥Ð¥¤¥À¤«¤é¥À¥¦¥ó¥í¡¼¥É¤Ï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¤¹¤ëÁ°¤Ë³°Éô¥­¡¼À©Ìó¤òºï½ü¤·¤Æ²¼¤µ¤¤¡£