PHPMyAdmin導(dǎo)入數(shù)據(jù)庫時(shí)MySQL報(bào)錯(cuò)“Got a packet bigger than ‘max_allowed_packet’ bytes”

Licess‘s Blog從Godaddy導(dǎo)入數(shù)據(jù)到DiaHosting的時(shí)候出現(xiàn)無法導(dǎo)入的情況,系統(tǒng)提示為:

Got a packet bigger than 'max_allowed_packet' bytes
這個(gè)信息是提示導(dǎo)入的文件超出了mysql設(shè)置允許導(dǎo)入文件的最大值,需要修改'max_allowed_packet參數(shù)。

修改方法:
在/etc/my.cnf的[mysqld]部分修改一句話:
max_allowed_packet=10M
這樣把最大值設(shè)置為10M。

重新啟動(dòng)數(shù)據(jù)庫,就可以了。

One Response to PHPMyAdmin導(dǎo)入數(shù)據(jù)庫時(shí)MySQL報(bào)錯(cuò)“Got a packet bigger than ‘max_allowed_packet’ bytes”

  1. tdaf8856 says:

    好。。

發(fā)表評(píng)論

(required)

This site uses Akismet to reduce spam. Learn how your comment data is processed.