Shulou(Shulou.com)05/31 Report--

This article mainly introduces MySQ export data report error Error 2020: Got packet bigger than 'max_allowed_packet' how to do, the article is very detailed, has a certain reference value, interested friends must read it!

MySQL uses mysqldump to export Datagram error

Mysql mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table

Solution:

Add the-- max_allowed_packet parameter to the export

[root@db-backup data] # mysqldump-urepl-p-h 10.11.10.243-P 3306-- max_allowed_packet=512M-Q\-- single-transaction-- master-data=2-- databases xxx > / data/20180810_ xxx.sql [root @ db-backup data] # mysqldump-- help | grep max postgresql, oracle, mssql, db2, maxdb, no_key_options -- max-allowed-packet=# The maximum packet length to send to or receive frommax-allowed-packet 25165824 and above are all the contents of the article "MySQ Export Datagram error Error 2020: what to do about Got packet bigger than 'max_allowed_packet'" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.