Error in MySQL dump

Discussion in 'MySQL' started by Alan|AzH, Mar 29, 2010.

  1. #1
    I took a back up of my forum, and I am pleased I did because I screwed an Impex import. However, the back up is corrupt when I asked my host to replace it.

    This is the message they sent.

    The mentioned sql file is corrupt and appears to have some HTML content in it.  Please is the error received when importing.
    
    ERROR 1064 (42000) at line 23945: 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 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w' at line 1
    
    Code (markup):
    Is there anything I can do to remove the html and get it to work again?
     
    Alan|AzH, Mar 29, 2010 IP
  2. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #2
    whats the size of the .sql file?
    if small, send it accross and we will fix it for you
     
    maestria, Apr 3, 2010 IP