Bug #67178 | Error on handle LOAD DATA INFILE LOCAL through lua script | ||
---|---|---|---|
Submitted: | 10 Oct 2012 12:58 | Modified: | 12 Jan 2013 7:46 |
Reporter: | Daniele Rondina (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Proxy | Severity: | S3 (Non-critical) |
Version: | 0.8.3 | OS: | Linux |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | Contribution, LOAD_DATA_INFILE_LOCAL |
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[10 Oct 2012 12:59]
Daniele Rondina
[10 Oct 2012 13:00]
Daniele Rondina
This patch clean sources and split event handler to permit an more readable code
Attachment: mysql-proxy-0.8.3-event_handler_split.patch (text/x-patch), 127.20 KiB.
[23 Nov 2012 9:08]
Daniele Rondina
Add a new version of previous patch without printf for debug
Attachment: mysql-proxy-0.8.3-event_handler_split.patch (text/x-patch), 126.85 KiB.
[15 Dec 2012 18:03]
Daniele Rondina
Example of lua script
Attachment: example_load_data_infile.lua (text/x-lua), 1.88 KiB.
[10 Jan 2013 18:21]
Sveta Smirnova
Test in my environment
Attachment: cantrepeat.txt (text/plain), 7.88 KiB.