Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using MySQL 5.1.36. While importing form a MySQL dump I am getting the following error. The 'max_allowed_packet' size is set to 100M in the my.cnf.

ERROR at line 1647: Unknown command '\''.

Can you please tell me what could be the issue ?

Warm Regards

Supratik

share|improve this question
2  
Could we see, say, lines 1640-1655 of the dump file? –  MadHatter Apr 11 '11 at 14:31
    
the data contains some binary data and it will be large enough to post here. The problem is it works sometimes and sometimes it throws the above error. How you want me to proceed ? –  Supratik Apr 11 '11 at 14:52
    
Are you saying that you can, starting each time from a clean and empty db, repeatedly import the same dump file, and sometimes it errors and sometimes it doesn't? –  MadHatter Apr 11 '11 at 14:56
    
We are taking dump from a production server every hour as a backup. When we try to restore from the dumps some of the dumps restore successfully and some fails with the above error. If a dump throws error while restoring first time it continuously throws error every time we try to restore it. –  Supratik Apr 11 '11 at 15:08
    
OK, then can we have a look at lines 1640-1655 of the dump file that reliably and repeatably throws an error at line 1647? It's only the line that throws the error, and a few lines either side, that are of interest; not the whole file. Also, how are you getting the file from the prod server to the box where the restore is done? –  MadHatter Apr 11 '11 at 15:27

2 Answers 2

If you have binary data use the mysqldump parameter --hex-blob.

share|improve this answer

You might try the --skip-extended-insert of mysqldump, that makes it use a new line for each insert and that can solve the problem particularly if you are editing the dump file.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.