[HELP] Mysql Syntax Error

[dani-filth0]

hi guyz
i dump my sql file " cq_action " then i used this query " delete from my2. cq_action " to clear it and remove all records ,
then i copy what in the dumped file , and past it on query page , and it keep give me this error

here is the line that might have the error
INSERT INTO `cq_action` VALUES ('5220942', '5220943', '0000', '0101', '0', 'only~then~disposable~grasps~the~jail.~Will~be~gra sped~again~next~time~the~external~jail,~I~must~han d~over');
INSERT INTO `cq_action` VALUES ('5220941', '5220942', '0000', '0101', '0', 'you~have~entered:~Pinch~was~wrong.~The~clear~sky~ is~the~use~external~several~days~later');
INSERT INTO `cq_action` VALUES ('5220940', '5220941', '0000', '0217', '0', 'will~be~grasped~the~external~jail~I~to~again~next ~time~pay~13,800~points~the~Eudemon~Points~only~th en~to~be~possible~to~leave');
INSERT INTO `cq_action` VALUES ('5220935', '4000011', '0000', '0103', '0', '70 5220940 Now start typing...');
INSERT INTO `cq_action` VALUES ('5220934', '5220935', '0000', '0101', '0', '13,800~point~Eudemon~Points~only~then~may~leave?) ;
INSERT INTO `cq_action` VALUES ('5220933', '5220934', '0000', '0101', '0', 'present,~entrance:~ \r\nPropill~be~grasped~the~external~jail~I~to~agai n~next~time~pay');
INSERT INTO `cq_action` VALUES ('5220932', '5220933', '0000', '0101', '0', 'only~then~disposable~grasps~the~jail?);

[dute_ma]

'only~then~disposable~grasps~the~jail.~Will~be~gra sped~again~next~time~the~external~jail,~I~must~han d~over'); ....u have to remove the space on hand...
~time~pay~13,800~points~the~Eudemon~Points~only~th en~to~be~possible~to~leave'); ...again here from Then...

[dani-filth0]

didnt work

[forcer]

INSERT INTO my.cq_action VALUES ('5220942', '5220943', '0000', '0101', '0', 'only~then~disposable~grasps~the~jail.~Will~be~grasped~again~next~time~the~external~jail,~I~must~han d~over');

you should not have linebreaks within quoted text.

[dani-filth0]

Originally Posted by forcer

INSERT INTO my.cq_action VALUES ('5220942', '5220943', '0000', '0101', '0', 'only~then~disposable~grasps~the~jail.~Will~be~grasped~again~next~time~the~external~jail,~I~must~han d~over');

you should not have linebreaks within quoted text.

but that was a dump file so it shall works , anyway , what should i do to aviod that error

[dani-filth0]

sry double post wrongly i hit on the button twice

[exodiac]

i have a probelm almost same ,
i dump my cq_action to tanslate it , after translating more than 200k lines , i tried to run the dump file ( after clearing cq_action ) but it didnt work and give error