[RESOLVED] Error 1064, migrating DB from one server to another

numerical25

I am recieving the following error

ERROR 1064 (42000): 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 '<!DOC
TYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w' at line 1
ERROR 1064 (42000): 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 '}

// ]]>
</script>
        <meta name="OBGZip" content="true" />
              ' at line 1
ERROR 1064 (42000): 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 '}

    </style>
    <![endif]-->
</head>

<body>
   ' at line 1
ERROR 1064 (42000): 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 '}
    // set current db, table and sql query in the querywindow
if (window.paren' at line 1
ERROR 1064 (42000): 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 '}

if (window.parent.frame_content) {
    // reset content frame name, as qu' at line 1
ERROR 1064 (42000): 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 '}
    if (typeof(window.parent.frame_content.id) != 'undefined'
     && window.p' at line 1
ERROR 1064 (42000): 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 '}
    //window.parent.frame_content.setAttribute('name', 'frame_content')' at line
 1
ERROR 1064 (42000): 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 '//win
dow.parent.frame_content.setAttribute('id', 'frame_content')' at line 1
ERROR 1064 (42000): 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 '}
})' at line 1
ERROR 1064 (42000): 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 '//]]>

</script>
</body>
</html>
&#9829;' at line 1

I have no idea how to resolve this. The DB is huge. about 230 tables. I always get this error on the 212th table. Both DB is utf 8 db's. dont know where to start to trouble shoot this. It appears that its trying to work with a table that has html in it. I would upload db, but its not my db and it has valuable data.

johanafm

Well,

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

is not a valid SQL statement, which means that you will get a syntax error if you try executing it as one.

On the other hand

SELECT someField FROM someTable

is a valid SQL statement and will give no syntax error. However, sending this to a browser will tell the browser nothing about what doctype is used, while sending the first string to a browser would.

numerical25

I ended up just importing tables in smalls groups. I was able to retrieve enough tables to get the application running. I am sure there is some data lost but my main intention was to get the site up and running. so everything is fine and thanks for the response.