mysql导出数据错误解决办法
mysqldump导出大数据表错误# 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
# mysqldump -u root -p --max-allowed-packet=64943040 --opt itop >/home/itop/itop-backup.sql
Enter password:
# ls
databases.sql itop-backup.sql
页:
[1]