Got " ERROR 1064 (42000) at line 806 " While restoring my SMF Forum backup

Discussion in 'MySQL' started by thewar, Apr 29, 2009.

  1. #1
    Hi Friends. I was just using the SMF forum approx 8 month ago on my other webhosting server, but I want to change my hosting provider so I just backup the SQL database file of SMF forum and just end my old hosting and move to Hostgator webhosting. But now when over here I try to restore back my SMF forum posts and SQL data It gives me this error.

    ERROR 1064 (42000) at line 806

    Any one know how to solve it? I also ask about it from my hosting provider and they give me this detailed response regarding it.

    <<<
    ERROR 1064 (42000) at line 806: 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 ''nadiash81@hotm@' at line 1
    >>>

    Now please do remember that my previous hosting account is totally finished and I can't re export the SQL of Forum in any way so I should have to fix this SQL to resume back my forum again. The SQL file size is approx 5.7MB.

    So Please do Help me regarding this.
    Thanks.
     
    thewar, Apr 29, 2009 IP