Csv Import Error

[billjones]

I get as far as error file not found after I select the file via the built in browser.

[Ritesh]

I am not sure if I understood your problem. Which option are you trying to use?

[billjones]

Ritesh wrote on Sep 2 2005, 10:42 AM:

I am not sure if I understood your problem. Which option are you trying to use?

[post=”7074″]<{POST_SNAPBACK}>[/post]

In the simple import/expot the import from csv file dialog goes until I select the csv file on my local machine, I click open (or whatever it says) and I then get an error, file not found.

[Ritesh]

Are you using HTTP Tunneling?

[billjones]

Ritesh wrote on Sep 2 2005, 11:40 AM:

Are you using HTTP Tunneling?

[post=”7078″]<{POST_SNAPBACK}>[/post]

yes

[Ritesh]

You cannot use “Import data from CSV” option in HTTP Tunneling. SQLyog uses MySQL's inbuilt LOAD LOCAL DATA INFILE… command to import data from a CSV file.

In HTTP Tunneling, the query is executed with respect to your remote server rather then your local machine as in the case of direct connection.

We plan to disable this option in v4.2 so that no confusion is created for the end user.

[Ritesh]

If you directly want to upload a local CSV File to a Remote Server ( being accessed over HTTP Tunnels ), you can use SQLyog's ODBC Import Wizard.

The ODBC driver that you could use is Microsoft Text Driver (*.txt, *.csv ) ODBC driver that ships with the OS.

[Author]

Posts