Bug #14709 LOAD DATA INFILE: Indexes get disabled by LOAD DATA
Submitted: 7 Nov 2005 15:30 Modified: 4 Feb 2010 11:56
Reporter: martin koegler Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.16-BK, 4.1.14 (4.1.15),5.0.16 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

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:

[11 Nov 2005 8:46] martin koegler
SHOW VARIABLES

Attachment: variables.txt (text/plain), 14.40 KiB.

[27 Nov 2005 13:22] Valeriy Kravchuk
Shell script to repeat the problematic behaviour

Attachment: 14709.sh (application/octet-stream, text), 1.18 KiB.

[27 Nov 2005 13:23] Valeriy Kravchuk
The results of the shell script

Attachment: 14709.txt (text/plain), 2.09 KiB.