TXT Plaintext import very slow

[expired user #8572]'s profile image [expired user #8572] posted 9 years ago in Import/Export Permalink
Hi,

I just the second time using Heidi...
My problem: I need to create a new DB from a *.txt plainfile.
This file is huge (2.4 GB).

1. Create a new DB -> Ok
2. Then i click on the "Open SQL Button" (the one with the scope)
3. Change filetype to txt and open the newDB.txt File
-> and now it runs, but this will take too much time (~23h).

The first time wenn I used Heidi i have to do the same.
But I think I used another (faster) turnaround. I try to remeber myself, but i do not come on it.

It was something like:
1. Create DB
2. Insert Tables -> Tools -> Text/BLOBs import
3. Use txt to fill the rows
But it pops an error: SQL Error (1064): Syntax Error -> use right syntax near: ') VALUES)' at line 1

INSERT INTO tbl VALUES (1,61006,22,'','2013-08-08','test','2013-12-17','Ktest');

Please login to leave a reply, or register at first.