> Sven Köhler wrote:
> >> I set the isolation level to READ_REPEATABLE and use mysqldump |
> >> bzip2 to get the result. I've tested the restore and it's fine!
> > So how does mysqldump handle binary data?
> > If it does embed the data into the SQL-statement somehow, that's crap,
> > since SQL-Statements are limited in length.
On Tue, 16 Dec 2003, Chris Nolan wrote:
> Are they? Shoving in rows that are several meg in size didn't pose any
> problems. The restore procedure looked like this:
> bunzip2 dumpfile | mysql -u db_grunt -p projectdb
> May I ask where the limitation you mentioned is documented? Maybe the
> situations we were using it in didn't come close to the limit.
This is limited by the max_packet_size variable.
In 3.23.x it's limited to 16Mb, in 4.0+ it is limited by 2Gb or the amount
of physical memory the machine has, whichever is less.