CODEWITHSUNDEEP
mysqlimportworkbench
Poketchu
Poketchu

Reputation: 13

Import issue with MySQL Workbench

I am trying to import a .csv (or .txt it doesn't matter) with MySQL Workbench and I am actually using the following command :

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

My .csv file is placed in the mysql/data folder of the server where my database is placed (on localhost). MySQL Workbench tells me "Query interrupted". I previously tried to put the full path but the query was running successfully without results. My database was still empty...

Thanks for your help.

Upvotes: 0

Views: 3546

Answers (1)

Poketchu
Poketchu

Reputation: 13

Okay so... Problem solved. It just seems that MySQLWorbench accepts this request with a direct path (no errors, script executed) but doesn't refresh his table view... So my table have been fullfilled around 3 times before I restarted MySQLWorkbench to discover that my table was full.

So... Problem solved. Sorry for the time loss.

Upvotes: 1

Related Questions