Thread: [adminer-tracker] [ adminer-Bugs and Features-3433561 ] csv import uses too much memory
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2011-11-04 15:18:01
|
Bugs and Features item #3433561, was opened at 2011-11-04 08:18 Message generated for change (Tracker Item Submitted) made by grizly You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.3.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jan (grizly) Assigned to: Jakub Vrána (jakubvrana) Summary: csv import uses too much memory Initial Comment: do not use the insert into method instead, use the "load data infile" statement: http://dev.mysql.com/doc/refman/5.5/en/load-data.html 12.2.6. LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 |
From: SourceForge.net <no...@so...> - 2011-11-25 07:48:30
|
Bugs and Features item #3433561, was opened at 2011-11-04 08:18 Message generated for change (Comment added) made by grizly You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.3.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jan (grizly) Assigned to: Jakub Vrána (jakubvrana) Summary: csv import uses too much memory Initial Comment: do not use the insert into method instead, use the "load data infile" statement: http://dev.mysql.com/doc/refman/5.5/en/load-data.html 12.2.6. LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. ---------------------------------------------------------------------- >Comment By: Jan (grizly) Date: 2011-11-24 23:48 Message: it would be nice if adminer automaticly matched the columns with the first line of a csv file. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 |
From: SourceForge.net <no...@so...> - 2012-12-16 07:40:04
|
Bugs and Features item #3433561, was opened at 2011-11-04 08:18 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.3.3 >Status: Closed >Resolution: Wont Fix Priority: 5 Private: No Submitted By: Jan (grizly) Assigned to: Jakub Vrána (jakubvrana) Summary: csv import uses too much memory Initial Comment: do not use the insert into method instead, use the "load data infile" statement: http://dev.mysql.com/doc/refman/5.5/en/load-data.html 12.2.6. LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2012-12-15 23:40 Message: Adminer uses ON DUPLICATE KEY UPDATE which is not available in LOAD DATA. ---------------------------------------------------------------------- Comment By: Jan (grizly) Date: 2011-11-24 23:48 Message: it would be nice if adminer automaticly matched the columns with the first line of a csv file. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3433561&group_id=264133 |