LOAD DATA LOCAL INFILE '/srv/$SPLIT_FOLDER/$f' INTO TABLE my_db.twitter_statuses_new FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (id,status_twitter_id,twitter_id,creator_twitter_identity_id,@text,in_reply_to_status_id,in_reply_to_user_id,@urls,@hashtags,created_at,updated_at,sent_at,@user_mentions) set text=replace(@text,'****',','),urls=replace(@urls,'\\n', '\n'), hashtags=replace(@hashtags,'\\n', '\n'), user_mentions=replace(@user_mentions,'\\n','\n');