phpmyadmin CSV import error driving me nuts..

CSU

I'm trying to import a list of local directory structures through phpmyadmin(I've been told by mysql on IRC to use the workbench, but iis refuses to run FTP/SSH for some reason so I'm sticking with phpmyadmin)

the CSV looks like this: "name";"description";"time";"\root\1\2\sample.jpg"

phpmyadmin breaks it by removing the backslash ie: root12sample.jpg because it thinks the "\" is an escape charecter...

anyone any ideas on how to get phpmyadmin to ignore it, I've tried setting "Fields escaped by" but no luck.

???

CSU

never mind :rolleyes:

I see it now :rolleyes:

:cool:

conorcan2

It might be handy to other people if you could give your solution.

CSU

absolutely right, my apology's.

(as far as I understand) Upon import phpmyadmin uses the backslash "\" as an escape character, so as soon as it read the "\" in the line it thought it was a command to insert into next line messing up the import.

It's the first time I've seen probs with this and usually linking to local directories is not a problem in code...

So instead of linking to local directories ie: \root\1\2\ simply have it link to the webserver directory ie: /www/root/1/2