isseium's blog

田舎に住むWebエンジニアのブログ

MySQL

ERROR 1153 (08S01) at line 47092: Got a packet bigger than 'max_allowed_packet' bytes

MySQL に dumpfile を食わせようとしたらこんなエラー $ mysql -u username -p --default-character-set=utf8 dbname < dump.sql Enter password: ERROR 1153 (08S01) at line 47092: Got a packet bigger than 'max_allowed_packet' bytesどうやら、データ…

PHP + MySQLの文字化け

UTF8に統一 php.ini default_charset = "UTF-8" mbstring.language = Japanese mbstring.internal_encoding = UTF-8 mbstring.http_input = auto my.conf init-connect=SET NAMES utf8 skip-character-set-client-handshake 未確認 my.conf のskip-character…