Load Data Local Infile Error MySQL

Load Data Local Infile Error MySQL

My "load data local infile" script for MySQL seems to be only uploading
the first record of the file and not the rest. My assumption is that it's
an issue with either how I'm terminated or escaping the records.
Here is my load data script:
load data local infile 'RXNSAB.RRF' into table RXNSAB fields terminated by
'|' ESCAPED BY ';' lines terminated by '\r\n'
(@vcui,@rcui,@vsab,@rsab,@son,@sf,@sver,@vstart,@vend,@imeta,@rmeta,@slc,@scc,@srl,@tfr,@cfr,@cxty,@ttyl,@atnl,@lat,@cenc,@curver,@sabin,@ssn,@scit)
SET vcui =@vcui,
rcui =@rcui,
vsab =@vsab,
rsab=@rsab,
son=@son,
sf=@sf,
sver=@sver,
vstart=@vstart,
vend=@vend,
imeta=@imeta,
rmeta=@rmeta,
slc=@slc,
scc=@scc,
srl=nullif(@srl,''),
tfr=nullif(@tfr,''),
cfr=nullif(@cfr,''),
cxty=@cxty,
ttyl=@ttyl,
atnl=@atnl,
lat=@lat,
cenc=@cenc,
curver=@curver,
sabin=@sabin,
ssn=@ssn,
scit=@scit;
And then part of the .RRF file it's trying to upload is this:
C3534900|C1876239|GS_2013_07_03|GS|Gold Standard Drug
Database|GS|2013_07_03|2007_05_04||2013AA||John Kilbourne, M.D.;Head, MeSH
Section;;;;;;;;;;kilbourj@mail.nlm.nih.gov;|Kay Morgan;;;;;;;;;(813)
579-3882;(813)
579-2786;morgan.k@goldstandard.com;|3||||CD,MTH_RXN_BD,BD,MTH_RXN_CD|AMBIGUITY_FLAG,NDC|ENG|UTF-8|Y|Y|Gold
Standard|;;;;Gold Standard Drug Database;;;;302 Knights Run Ave, Suite
800, Tampa, FL 33602;Gold Standard;;;;;;;;|
C3534899|C1140224|MDDB_2013_07_03|MDDB|Master Drug Data
Base|MDDB|2013_07_03|||2013AA||Karen Eckert, RPh;;Medi-Span;8425 Woodfield
Crossing Blvd., Suite 490;;Indianapolis;IN;United States;46240;(800)
388-8884;(317) 735-5390;Keckert@drugfacts.com,
ms-support@drugfacts.com;http://www.medi-span.com/products/product_mddb.asp|;;;;;;;;;;;BPettijohn@drugfacts.com;|3||||CD||ENG|UTF-8|Y|Y|Master
Drug Data Base|;;;;Master Drug Data Base;;;July 03, 2013;;;;;;;;;;|
||ATC_2013|ATC|Anatomical Therapeutic Chemical Classification
System|ATC|ATC_2013|||2013AA||;;WHO Collaborating Centre for Drug
Statistics Methodology;Norwegian Institute of Public Health;P.O.Box 4404
Nydalen;Oslo;;Norway;0403;+47 21 07 81 60;+47 21 07 81
46;whocc@fhi.no;http://www.whocc.no/copyright_disclaimer/|;;WHO
Collaborating Centre for Drug Statistics Methodology;Norwegian Institute
of Public Health;P.O.Box 4404 Nydalen;Oslo;;Norway;0403;+47 21 07 81
60;+47 21 07 81
46;whocc@fhi.no;http://www.whocc.no/|3||||IN,RXN_PT,RXN_IN,PT|IS_DRUG_CLASS,ATC_LEVEL|ENG|UTF-8|Y|Y|Anatomical
Therapeutic Chemical Classification System|;;WHO Collaborating Centre for
Drug Statistics Methodology;;Anatomical Therapeutic Chemical (ATC)
classification system;;;2013;Oslo, Norway;WHO Collaborating Centre for
Drug Statistics
Methodology;;;;;;http://www.whocc.no/copyright_disclaimer/;;;;|
C3534898|C1140218|MMSL_2013_07_01|MMSL|Multum MediSource
Lexicon|MMSL|2013_07_01|||2013AA||;;Multum Information Services;3200
Cherry Creek South Drive, Suite 300;;Denver;CO;United
States;80209;888-633-4772 x1420;;;http://www.multum.com/|;;Multum
Information Services;3200 Cherry Creek South Drive, Suite
300;;Denver;CO;United States;80209;888-633-4772
x1420;;;http://www.multum.com/|1||||IN,CD,MTH_RXN_BD,MS,BN,GN,BD,SC|DDF,DDFA,DCSA,DPC,DST,DRT,DHJC,TYPE,NDC,DRTA|ENG|UTF-8|Y|Y|Multum|;;;;Medisource
Lexicon;;;July 01, 2013;Denver, CO;Multum Information Services,
Inc.;;;;;;;;
Where the Records should be something like:
C3534900|C1876239|GS_2013_07_03|GS|Gold Standard Drug
Database|GS|2013_07_03|2007_05_04||2013AA||John Kilbourne, M.D.;Head, MeSH
Section;;;;;;;;;;kilbourj@mail.nlm.nih.gov;|Kay Morgan;;;;;;;;;(813)
579-3882;(813)
579-2786;morgan.k@goldstandard.com;|3||||CD,MTH_RXN_BD,BD,MTH_RXN_CD|AMBIGUITY_FLAG,NDC|ENG|UTF-8|Y|Y|Gold
Standard|;;;;Gold Standard Drug Database;;;;302 Knights Run Ave, Suite
800, Tampa, FL 33602;Gold Standard;;;;;;;;|
C3534899|C1140224|MDDB_2013_07_03|MDDB|Master Drug Data
Base|MDDB|2013_07_03|||2013AA||Karen Eckert, RPh;;Medi-Span;8425 Woodfield
Crossing Blvd., Suite 490;;Indianapolis;IN;United States;46240;(800)
388-8884;(317) 735-5390;Keckert@drugfacts.com,
ms-support@drugfacts.com;http://www.medi-span.com/products/product_mddb.asp|;;;;;;;;;;;BPettijohn@drugfacts.com;|3||||CD||ENG|UTF-8|Y|Y|Master
Drug Data Base|;;;;Master Drug Data Base;;;July 03, 2013;;;;;;;;;;|
||ATC_2013|ATC|Anatomical Therapeutic Chemical Classification
System|ATC|ATC_2013|||2013AA||;;WHO Collaborating Centre for Drug
Statistics Methodology;Norwegian Institute of Public Health;P.O.Box 4404
Nydalen;Oslo;;Norway;0403;+47 21 07 81 60;+47 21 07 81
46;whocc@fhi.no;http://www.whocc.no/copyright_disclaimer/|;;WHO
Collaborating Centre for Drug Statistics Methodology;Norwegian Institute
of Public Health;P.O.Box 4404 Nydalen;Oslo;;Norway;0403;+47 21 07 81
60;+47 21 07 81
46;whocc@fhi.no;http://www.whocc.no/|3||||IN,RXN_PT,RXN_IN,PT|IS_DRUG_CLASS,ATC_LEVEL|ENG|UTF-8|Y|Y|Anatomical
Therapeutic Chemical Classification System|;;WHO Collaborating Centre for
Drug Statistics Methodology;;Anatomical Therapeutic Chemical (ATC)
classification system;;;2013;Oslo, Norway;WHO Collaborating Centre for
Drug Statistics
Methodology;;;;;;http://www.whocc.no/copyright_disclaimer/;;;;|
C3534898|C1140218|MMSL_2013_07_01|MMSL|Multum MediSource
Lexicon|MMSL|2013_07_01|||2013AA||;;Multum Information Services;3200
Cherry Creek South Drive, Suite 300;;Denver;CO;United
States;80209;888-633-4772 x1420;;;http://www.multum.com/|;;Multum
Information Services;3200 Cherry Creek South Drive, Suite
300;;Denver;CO;United States;80209;888-633-4772
x1420;;;http://www.multum.com/|1||||IN,CD,MTH_RXN_BD,MS,BN,GN,BD,SC|DDF,DDFA,DCSA,DPC,DST,DRT,DHJC,TYPE,NDC,DRTA|ENG|UTF-8|Y|Y|Multum|;;;;Medisource
Lexicon;;;July 01, 2013;Denver, CO;Multum Information Services,
Inc.;;;;;;;;