mysql:12057
From: tatematsu <tatematsu <tatemax@xxxxxxxxxx>>
Date: Fri, 02 Sep 2005 19:28:31 +0900
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¤¹¤ëÁ°¤Ë³°Éô¥¡¼À©Ìó¤òºï½ü¤·¤Æ²¼¤µ¤¤¡£ > ¤³¤ó¤Ë¤Á¤Ï¡£Î©¾¾¤Ç¤¹¡£ > > mysql$ mysql < backup.sql > ¤Ç¤Ï¡¢¤À¤á¤Ç¤¹¤«¡© > > WindowsÈǤϻȤ俤³¤È̵¤¤¤Î¤Ç¤Ï¤è¤¯²ò¤ê¤Þ¤»¤ó¤¬¡£ > > > ½é¿´¼Ô¤Î£Ç£Å£Ï£È£Á£Ó£Å¤Ç¤¹¡£ > > ¥×¥í¥Ð¥¤¥À¤ÇCOOPS¤ò»È¤Ã¤Æ¡¢£Í£ù£Ó£Ñ£Ì¤Î¥Ç¡¼¥¿¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×Ãפ·¤¿¤¯ > > ¥À¥ó¥×¤·¤¿¤Î¤Ç¤¹¤¬¡¢¤Þ¤À¼Â¸³Åª¤Ë»È¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢Ìó1Ëü¹Ô¤Ç¥Æ¡¼¥Ö¥ë > > ¼«ÂΤâ100¶á¤¯¤Ë¤Ê¤ê¤Þ¤¹¡£ > > ¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤Ï³Æ¥Æ¡¼¥Ö¥ëËè¤ËCreate Tableʸ¤È¥À¥ó¥×¥Ç¡¼¥¿¤È¤·¤Æ > > Insertʸ¤Î¥Ç¡¼¥¿¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡Ê¥Ç¡¼¥¿¹½Â¤¤ä¥À¥ó¥×¥Ç¡¼¥¿¤È¤¤¤Ã¤¿ÀâÌÀʸ¤Î > > Éôʬ¤Ï--¤Ç̵¸ú¡Ë¡£ > > ¤³¤Î¥Ç¡¼¥¿¤ò¥í¡¼¥«¥ë¤ÇMySQL¤ËÆɤ߹þ¤Þ¤»¤¿¤¤¤È»×¤¦¤Î¤Ç¤¹¤¬¡¢¥³¥Þ¥ó¥É¤«¤é > > ÆþÎϤÏÇ¡²¿¤Ë¤âÂçÊѤʤΤǡ¢²¿¤«¥½¥Õ¥ÈÅù¤¬¤¢¤ë¤Î¤«¤È»×¤¤¤Þ¤¹¤¬¡¢¤´¶µ¼¨ > > 失¤ì¤Ð¤È¥á¡¼¥ë¤ª´ê¤¤Ãפ·¤Þ¤¹¡£ > > ¤Ê¤ª¥í¡¼¥«¥ë¤Ç¤ÏApche2¡¦MySQL4.0¡¦PHP5¤ò»È¤Ã¤Æ¤ª¤ê¡¢£Ï£Ó¤Ï£×£é£î£Ø£Ð¤Ç > > Apche¡¦MySQL¶¦¤ËWindows¤Î¥µ¡¼¥Ó¥¹¤Ç»È¤Ã¤Æ¤¤¤Þ¤¹¡£ > > > > > > >
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]