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