Bug #63086 Foreign key constraint fails when using TRUNCATE TABLE
Submitted: 3 Nov 2011 10:12 Modified: 3 Nov 2011 10:16
Reporter: Benjamin Morel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.6.3-m6 OS:Linux (verified on Linux CentOS 5 + Windows XP)
Assigned to: CPU Architecture:Any
Tags: foreign keys, innodb, truncate table

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file: