[HELP] Mysql Syntax Error

02/11/2009 14:35 dani-filth0#1
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 [Only registered and activated users can see links. Click Here To Register...]

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?);
02/11/2009 14:56 dute_ma#2
'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...
02/11/2009 15:29 dani-filth0#3
didnt work
02/11/2009 19:47 forcer#4
Code:
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.
02/11/2009 20:53 dani-filth0#5
Quote:
Originally Posted by forcer View Post
Code:
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
02/11/2009 20:54 dani-filth0#6
sry double post wrongly i hit on the button twice
02/12/2009 19:04 exodiac#7
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