MySQL Forums :: Newbie :: load data errror ONLY on remote server


Advanced Search

load data errror ONLY on remote server
Posted by: P Farrell ()
Date: June 18, 2014 01:59AM

Why am I only getting an error on loading data for the remote server but not on local host

when I print the sql string for the local host it is as follows :-

LOAD DATA LOCAL INFILE 'C:\/wamp\/tmp\/phpE66B.tmp' INTO table import_customers FIELDS TERMINATED BY ' ' LINES TERMINATED BY ' ' IGNORE 1 ROWS (cust_id,customer_name,address1,address2,address3,town,county,postcode,telephone ,email,fax,website,engineer,areamanager,comments,customer_type,aquaa,pref_dist ,buying_group,parent_company,direct_account,bsa_account,cla_account,branchcode_altreference ,category,grade,curr_year_sales,prev_year1_sales,prev_year2_sales,events_not_completed,actions_not_completed ,last_event,bywhom,next_event,total_products)


works fine..

EXACTLY the same routine running from remote server loading exactly the same fle from my pc

LOAD DATA LOCAL INFILE '/tmp/phpVOfRsU' INTO table import_customers FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' IGNORE 1 ROWS (cust_id,customer_name,address1,address2,address3,town,county,postcode,telephone ,email,fax,website,engineer,areamanager,comments,customer_type,aquaa,pref_dist ,buying_group,parent_company,direct_account,bsa_account,cla_account,branchcode_altreference ,category,grade,curr_year_sales,prev_year1_sales,prev_year2_sales,events_not_completed,actions_not_completed ,last_event,bywhom,next_event,total_products) Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROWS (cust_id,customer_name,address1,address2,address3,town,county,postcode' at line 5


Its the same routine, same file ?

Any help

Options: ReplyQuote


Subject Written By Posted
load data errror ONLY on remote server P Farrell 06/18/2014 01:59AM
Re: load data errror ONLY on remote server Shawn Green 06/25/2014 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.