Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am running MySQL on an Apple server OS X 10.6 (and am a complete newbie to SQL). I am trying to import a .SQL export file that was generated by an application called MailSteward Pro. The .SQL file is an email database about 88 Gigs in size. When I do the import operation in Sequel Pro, I see a progress bar that goes almost all the way to the end (takes hours, shows no problems), but then suddenly shows a message that says

[ERROR in query 650009] You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near "\d\">+B$?\"+vq+q6]\Vss<:t/qs4>{]:>' at line 1

what in the world does this mean and how do I figure out why I can't import my saved .SQL file? It goes most of the way to the end and shows only 260,000 emails instead of 290,000. What's my next step - how do I debug this and import as much as possible of this database? Maybe check it for errors somehow, or have it ignore the bad record and move past it to import the rest?

share|improve this question
1  
How do you think we can help you if you don't show us the SQL that causes the error? –  a_horse_with_no_name May 26 '13 at 9:51
    
You might be able to gather further information about the specific SQL being run by running grep '+vq+q6]' /path/to/file.SQL from a terminal session. –  Nathan Jolly May 27 '13 at 1:30
add comment

migrated from stackoverflow.com May 26 '13 at 20:47

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

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