mysqldum 导出大数据表错误
- [root@Centos-6-99 itop]# mysqldump -u root -p --opt itop>/home/itop/itop-backup.sql
- Enter password:
- mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table attachment at row: 1
解决办法: 增加 mysqldump 的 max_allowed_packet
- [root@Centos-6-99 itop]# mysqldump -u root -p --max-allowed-packet=64943040 --opt itop>/home/itop/itop-backup.sql
- Enter password:
- [root@Centos-6-99 itop]# ls
- databases.sql itop-backup.sql
来源: http://www.bubuko.com/infodetail-2732260.html