[jrw]

Parallels is actually pretty awesome at reading files which are held on the OS-X platform. I have the My Documents folder in Windows XP running in the Parallels VM mapped to the Documents folder in OS-X and it works fine – this is the first time I have had this problem.

What is more curious is that although I had the problem importing data from the csv file, I haven't had a problem running a .sql script (held in the same directory as the csv file) via the Tools > Restore From SQL Dump…. menu option. So SQLyog seems to be able to read the path that Parallels creates in some circumstances but not in others, which is a little strange.

[jrw]

Good thinking. It doesn't matter where I put it on my pc – it wouldn't import. So I put the file on a remote server and imported from there and Bingo!

Thanks for your help.

John

[jrw]

Apologies, version is 6.56.

[jrw]

'peterlaursen' wrote on '17:

What is the SQlyog version? There are different ways to import from CSV-files (depending on SQLyog version). Are you using the option to use LOAD DATA syntax or the ODBC-based option?

I think from your description it is LOAD DATA and in that case you can see the SQL-statement executed by SQLyog in HISTORY tab.  If you find the statement there it will likely also fail from the editor (or any other client)- Please check.

It looks very much like an issue with mapping of drive letters in 'parallels'. I do not know this very well. But please first try to identify and (dis)verify the statement.

Peter, thanks.

I am using the LOAD DATA option. I had my suspicion about the drive mapping. Having checked the History tab it is trying to load using this line.

load data local infile '\\.psf\Home\Documents\Pentathlon\MPAGB\Competitions\Results\Biathle\WeymouthWebresults2010.csv' into table `MPAGB`.`tblResultsBiathle_update` fields escaped by '\' terminated by 't' lines terminated by 'n' (`result_id`, `event_id`, `individual_id`, `age_group`, `biathle_time_mins`, `biathle_time_secs`, `biathle_points`, `ranking`);

Am I stuck or can you suggest a solution?

Thanks

John

[jrw]

Peter

That's great, thanks. Option 1 worked a treat.

Many thanks for your prompt response.

John

[Author]

Posts