import csv with slashs and backslashes

[bookouri]

Im trying to import a csv file into a mysql database. The load fails, i think because the data has \'s. My csv file contains file names and locations so every line has something like myfile.txt,c:\temp\myfolder\,Text File,2008-03/03,50k. Im guessing that problem is the \'s. Can anybody give me any suggestion about how to get mysql to ignore the \'s? Or am I off base entirely?

There's too many rows to manually edit every row and I dont have any control over the app that creates the csv file i have to work with.

thanks for any suggestions

 

[r937]

the slashes make no difference

explain more about how the load fails

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[bookouri]

I cant get the exact info on the load now because after I rebooted my pc mysql will not start anymore. I had not rebooted since installing mysql but after a reboot, it wont start.

now im trying to get it restarted and researching the error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Im guessing that thats because mysql wont start.

In windows im logging:
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist



but havnt had any luck yet...