Error 1064 (42000)

Question

I am a totally newbie to this so please be patient with me.

I had to change hosts. All my previous hosts had cPanel and back-up tools in there that did all the work. This time my host doesn't so I have to manually transfer the MqSQL DB over.

I'm able to login and all that. I'm executing the following command:

mysql -h internal-db.s00000.gridserver.com -u username -p dbname < dbname.sql

Obviously I changed the variables to my information.

I get the following error:

ERROR 1064 (42000) at line 210 in file: 'bellemb_belle.sql': 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 ''????%Exif\0\0II*\\0\0\0  \0\0\0\0\0z\0\0\0\0
\0\0\0?\0\0\0\0\0\0\0' at line 1

I opened up my .sql file and on line 120 and it's this LONG, LONG line filled with random characters. It begins like this:

INSERT INTO `xmb_attachments` (`aid`, `tid`, `pid`, `filename`, `filetype`, 
`filesize`, `attachment`, `downloads`, `fileheight`, `filewidth`) VALUES (7, 4,
445, '1stbday3.jpg', 'image/jpeg', '254329', 'ˇÿˇ·yûExif\0\0II*\0\0\0\0 \0\0\0
\0\0z\0\0\0\0\0\0\0Ä\0\0\0\0\0\0\0\0\0\0\Z\0\0\0\0ñ\0\0\0\0\0\0\0û\0\0\0(\0\0\0
\0\0\0\02\0\0\0\0¶\0\0\0\0\0\0\0\0\0\0iá\0\0\0\0ª\0\0\0˘\n\0\0Canon\0Canon 
PowerShot SD600\0¥\0\0\0\0\0\0¥\0\0\0\0\0\02008:09:05 01:49:10\0\0\0öÇ\0\0\0\05
\0\0ùÇ\0\0\0\0=\0\0\0ê\0\0\0\00220ê\0\0\0\0E\0\0ê\0\0\0\0Z\0\0ë\0\0\0\0\0ë\0\0
\0\0o\0\0í\n\0\0\0\0w\0\0í\0\0\0\0\0\0í\n\0\0\0\0á\0\0í\0\0\0\0è\0\0í\0\0\0\0\0
\0\0    í\0\0\0\0X\0\0\0\ní\0\0\0\0ó\0\0|í\0ˇ\0\0ü\0\0Üí\0\0\0û \0\0\0†\0\0
\0\00100†\0\0\0\0\0\0\0†\0\0\0\0,\0\0†\0\0\0\0Á\0\0†\0\0\0\0æ\n\0\0¢\0\0\0\0¶\n
\0\0¢\0\0\0\0Æ\n\0\0¢\0\0\0\0\0\0\0¢\0\0\0\0\0\0\0\0£\0\0\0\0\0\0\0§\0\0\0\0\0
\0\0\0§\0\0\0\0\0\0\0\0§\0\0\0\0\0\0\0\0§\0\0\0\0∂\n\0\0§\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\02\0\0\0(\0\0\0\n\0\0\02008:08:30 00:48:02\0\02008:08:30 00:48:02\0\0\0\0
\0\0\0\0µ\0\0\0 \0\0\0Ä\0\0\0 \0\0\0\0\0\0\0\0\0\0Ä\0\0\0 \0\0\0X/\0\0Ë\0\0\0\0
\0\0\0\0\0â\0\0\0\0.\0\0\0ï\0\0\0\0\0\0\0Ò\0\0\0\0\0\0\0˘\0\0\0\0\"\0\0\0\0\0\0
\0\0\0\0E\0\0\0\0\0\0\0^\0\0\0\0\0\0\0ò/\0\r\0\0h\0\0\0t\0\0\0\0\0\0\0\0\0ó\0\0
\0\0\0\0\0\0\0\0\0\0L\0\0\0\0\0\0\0T\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0T\0\0\0\0\0\0\0\0\0\0\0E\0\0\0t\0\0\"\0\0–\0\0\0˛\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\\\0\0\0\0\0\0\0\0\0\0\0ˇˇ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0@\0\0ˇˇˇ¯C®
ËÄ\0¿\0ˇˇ\0\0\0\0\0\0\0\0\0\0ˇˇ\0\0\0\0\0\0\0\0ˇˇ\0\0ˇˇ\0\0\0\0\0X/Ê\0≠

I'm so lost. Please help!

I expect there is a mismatch in the collation/enconding setting. Maybe this helps: http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf because your file looks fine but the server is not showing the correct characters — rene, Sep 07 '13 at 16:16
I think the file may not be okay? Let me post more of what's in Line 210: \0\0\0\0\0\0\0\0\0\0 \n\0\0\0}\0!1AQa\"q2Åë°#B±¡R—$3brÇ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzÉÑÖÜáàâäíìîïñóòôö¢£§•¶ß®©™≤≥¥µ∂∑∏π∫¬√ƒ≈∆«»… “”‘’÷◊ÿŸ⁄·‚„‰ÂÊÁËÈÍÒÚÛÙıˆ˜¯˘˙\0\0\0\0\0\0\0 \n\0\0w\0!1AQaq\"2ÅBë°±¡ #3Rbr—\n$4·%Ò\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzÇÉÑÖÜáàâäíìîïñóòôö¢£§•¶ß®©™≤≥¥µ∂∑∏π∫¬√ƒ≈∆«»… “”‘’÷◊ÿŸ⁄‚„‰ÂÊÁËÈÍÚÛÙıˆ˜¯˘˙ˇ⁄\0\0\0?\0˙GHºOÅf—>hó6˜_Ÿvâm¶…p — jkb, Sep 07 '13 at 16:33
$¶N/üÀ gho°—Á∂˙¥~™i≤›¡sıÆïY#ûﬂ÷ˇ\0]=äfø5Òõrc…ñ˘”è¯;[Ùº˙ÖÕ?‰KcÉÎ ÃO •TùZÉa◊±5˝X™!©Nã˜üÈàUE:üÇ”Ê¶* u˚œÙ≈UTÍÔ?”UÅ‘{˜üÈé…›zùC∏y˛òÏª™)ø_ºˇ\0Lï∫ﬁo≤˝Á˙c≤wn∑~ø3˝0l≠≠◊`+Û?” ºŒ‡}Á˙c≤¥>µ^ò´È^Ô«eiæ±ÅVˇ\0•rÈ¯‰êˇ\0ˇŸ',249,'525','700'); — jkb, Sep 08 '13 at 07:15

Error 1064 (42000)

0 Answers0