Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

[Chris Nolan]

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.

Regards,

Chris

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.
>
>