Why can I insert large data into an external MySQL database?
From the MySQL documentation: “The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you can actually transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size, but you must do so on both the server and client ends. See section 10.1 Tuning server parameters.” “max_allowed_packet The maximum size of one packet. The message buffer is initialized to net_buffer_length bytes, but can grow up to max_allowed_packet bytes when needed. This value by default is small to catch big (possibly wrong) packets. You must increase this value if you are using big BLOB columns. It should be as big as the biggest BLOB you want to use.” So if you add a line like max_allowed_packet = 4M to the file my.cnf everything should work fine.
Related Questions
- How large is amount of service traffic circulating within XdbE network while the network is idle (when there are no external requests and data provisions and all servers are synced)?
- Managing your MySQL Database Systems ยป Data Types and Storage Engines: How does SQLyog handle TIMESTAMPS defined as ... on UPDATE CURRENT_TIMESTAMP ?
- Can I export data to an external database or spreadsheet program?
