* Ahmed S K Anis [...] > String filepath = "sys:\\restore\\data1.txt"; > String query = "load data local infile \'" + filepath + "\' into table > x > > it takes as estoredata1.txt as file name not clear why ?
A double backslash will in many environments be reduced to a single backslash. Your result indicate that you are in such an environment (VBA?), as mysql only sees single backslashes: mysql> select "sys:\restore\data1.txt"; +----------------------+ estoredata1.txt | +----------------------+ estoredata1.txt | +----------------------+ 1 row in set (0.00 sec) Try to double your backslashes twice: String filepath = "sys:\\\\restore\\\\data1.txt" Your programming environment will remove every other backslash, so that mysql sees this: mysql> select "sys:\\restore\\data1.txt"; +------------------------+ | sys:\restore\data1.txt | +------------------------+ | sys:\restore\data1.txt | +------------------------+ 1 row in set (0.00 sec) -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
