¥Õ¥£¡¼¥ë¥É¤Î¹Ô¿ô¤¬¿ô½½Ëü¹Ô¤¢¤ë¥Ç¡¼¥¿¤Î¥¤¥ó¥Ý¡¼¥È¤Ç¾å¼ê¤¯¤¤¤«¤Ê¤«¤Ã¤¿¤Î¤Ç¥á¥â¡£
º£¸å²¿ÅÙ¤âÆ±¤¸ÌäÂê¤Ë¤Ö¤Ä¤«¤ê¤½¤¦¤Ê¤Î¤Ç¡¢¤Ä¤¤¤Ç¤Ë¥Ð¥Ã¥¯¥¢¥Ã¥×¤ÎÊýË¡¤â¥á¥â¥á¥â¡£
´Ä¶¤ÏWindows+xammp, MySQL5.0.51
¢£phpMyAdmin¤Ç¤Ï¸Â³¦¤¬¡¦¡¦¡¦
ºÇ½éphpMyAdmin¤ÇSQL¥Õ¥¡¥¤¥ë¤Î¥¤¥ó¥Ý¡¼¥È¤ò»î¤ß¤¿¤¬¤ß¤´¤È¤Ë¼ºÇÔ¡£
¼ç¤Ê¸¶°ø¤Ï¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬¤Ç¤«¤¹¤®¤ë¡£
PHP¥á¥â¥ê¤È¼Â¹Ô»þ´Ö¤Î¾å¸Â¤¬¸¶°ø¤Ç¤Ï¤Ê¤¤¤«¤È»×¤¦¤¬¡¢¸¶°ø¤¬»×¤¤Åö¤¿¤ê¤¹¤®¤Æ¤è¤¯¤ï¤«¤é¤ó¤Î¤Ç³ä°¦¡£
¤È¤ê¤¢¤¨¤ºcmd¤ÇÉü¸µ¤ò»î¤ß¤ëÊýË¡¤ËÊѹ¹¤·¤Þ¤·¤¿¡£
¢£Éü¸µ
C:\xampp\mysql\bin> mysql --default-character-set=utf8 -u root -p dbname < /home/backup.sql
¤ÇSQL¥Õ¥¡¥¤¥ë¤Î¥¤¥ó¥Ý¡¼¥È¤ò¹Ô¤¤¤Þ¤¹¡£
C:\xampp\mysql\bin¤ÏMySQL¤Î¥¤¥ó¥¹¥È¡¼¥ë¥Ñ¥¹¤Ê¤Î¤ÇŬµ¹½ñ¤´¹¤¨¤Æ¡£
/home¤Ï¥Ð¥Ã¥¯¥¢¥Ã¥×¥Õ¥¡¥¤¥ë¤Î¥Ñ¥¹¤Ê¤Î¤ÇŬµ¹½ñ¤´¹¤¨¤Æ¡£
dbname¤ÏŬÅö¤Ê¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤Ë½ñ¤´¹¤¨¤Æ¡£
º£²ó¤ÏUTF8¤À¤Ã¤¿¤Î¤Ç¡¢Ç°¤Î¤¿¤á--default-character-set=utf8¤ò»ØÄê¡£
¤¿¤À¡¢¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬½½¿ôMB¤â¤¢¤Ã¤¿¤¿¤á¼¡¤Î¤è¤¦¤Ê¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤¬¢
ERROR 2006 (HY000) at line **: MySQL server has gone away
¡Ê**¹ÔÌܤÇMySQL¥µ¡¼¥Ð¡¼¤¬¤É¤Ã¤«¹Ô¤Ã¤¿¡Ë
¸¶°ø¤Ï¥¤¥ó¥Ý¡¼¥È¤·¤è¤¦¤È¤·¤¿¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬¤Ç¤«¤¹¤®¤¿¤ß¤¿¤¤¤Ç¤¹¡£
C:\xampp\mysql\bin> mysql --default-character-set=utf8 --max-allowed_packet=32M -u root -p dbname < /home/backup.sql
¤È½ñ¤´¹¤¨¤Æ¥ê¥È¥é¥¤¡£
¤Þ¤¿¤Þ¤¿ERROR 2006 (HY000) at line **: MySQL server has gone away
»ÅÊý¤Ê¤¤¤Î¤Ç¡¢MySQLÀßÄê¥Õ¥¡¥¤¥ë¤ò½ñ¤´¹¤¨¤Þ¤¹¡£
C:\xampp\mysql\bin\my.cnf
¤Î
max_allowed_packet = 1M
¤ò
max_allowed_packet = 32M
¤ËÊѹ¹¤·¤Æ¡¢MySQL¤òºÆµ¯Æ°¡£
º£Å٤Ϥ¦¤Þ¤¯¹Ô¤¤Þ¤·¤¿¡£
¡Ê¥¹¥Ã¥¥ê¡Ë
¢£¥Ð¥Ã¥¯¥¢¥Ã¥×
C:\xampp\mysql\bin> mysqldump --default-character-set=utf8 -u root -p dbname > /home/dumpdata.sql
¤³¤ì¤Ç»ØÄꤷ¤¿¥Ñ¥¹¤Ë»ØÄꤷ¤¿¥Õ¥¡¥¤¥ë̾¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¤¬¼è¤ì¤Þ¤¹¡£
dbname¤Î¸å¤Ë¥Æ¡¼¥Ö¥ë̾¤ò»ØÄê¤Ç¤¤ë¡£
¾¤Ë¤â¥ª¥×¥·¥ç¥ó¤¬¤¢¤ë¤Î¤Ç¡¢
http://dev.mysql.com/doc/refman/4.1/ja/mysqldump.html¤¢¤¿¤ê¤ò»²¹Í¤Ë¡£
ÆÃ¤ËÂ礤ʥǡ¼¥¿¥Ù¡¼¥¹¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ëºÝ¤Ë¤ÏMySQL¥µ¡¼¥Ð¡¼¤Î¥á¥â¥ê¤ËÉé²Ù¤¬Â礤¯¤Ê¤ë¤½¤¦¤Ê¤Î¤Ç¡¢Å¬¤·¤¿¥ª¥×¥·¥ç¥ó¤ò»ØÄꤷ¤¿Êý¤¬¤è¤µ¤½¤¦¤Ç¤¹¡£
¤³¤Îµ»ö¤Ø¤Î¥³¥á¥ó¥È°ìÍ÷