G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 > rt2.dump Enter password: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table 'Attachments' at row: 36763
How can I find row 36763 and possibly correct this problem? I've looked at
the autoincrement field, id # 36763, but that doesn't seem to be a problem
record.
How can I locate the record referenced by that row number?
you mean SELECT * from Attachments WHERE id='36763'; ?
It seems to me that you've got a very big blob somewhere that is bigger than the max_allowed_packet in you my.cnf
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
