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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]