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

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]