Problem Importing Database Back-Up

Agent

New Member
I just purchased a new host and now I'm trying to use my .sql back up file (I added Drop Tables + gzip compression). When I try to do so, I get this error:

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNrt0t9PW1UcAPAle1AvD81eXEyc9ywh7IVeuJ0dtH24IaRhhh9FyobOScMQak1b2GjpVtbeRGOa
ZXFz2QMaRUxmgqbEsl8y08B16xAWzIiOrEpXburGtOlo+dlbeu89x27+G99vzsM33+/J+Z5z8jG3
tVnajKieRfU61GRuMaJqxKIavUFPWdtLDZqirEdL1fK3PjCigZPO/q5TAz2nGKfjBNP/YT9iWT17
EOmqq2u1paWrRewhI1tj1B88hpw9LgMqp5rPWN9uMiI9U83o2S5td5/L5XU7PGeoI9Y2ZLFWoroG
c0t7JTpqLk3rcLhRg7m+0YJYxkC1NtcZkY5hSznzJtV6uPX5pkqL9flpOuYQanK4vaepprqWBiPq
cWu9nl5tLfViGn3+5V0vYvdd1XG5++dLuVeE+Nicffk7//ixwMTu5MPeyfIjYvg115Uev//H9xvZ
uct72nWHX703N744RleWa77+xVDh9Jg8u3bmxqMVJ719HlP3On31VrccW18giptcI8l4riOSWY1y
xCYEpMxkXF3AO6NiIKuZ3XbLF/DHn9u+sLVKU8MPHCRCNqps02d3PlXD8UiZ1CH8mT8g10ub5Krp
G7yd7J087ux8Npx9j0yJ+dDMvXeL88WbJO4jv3NTV55EfTcyv0Vn0vv2k6VzPl4ZkVc46aXzU9+S
7ZGCWSr74ZEFFzhcyJI3ppv5/Xz+OkfW9krnOCWrEXBKJJMiScUkXp2nK+wekyKKJB/hzhZiOU4R
OCWtIQlBfWbn5GGiklnTH5d8WQ1O0EE5oxGKtEjSsk1dCXGBCbG4Fhbx05BIVkSS4OcDcpLgKjIY
vzMaLGzaeHmYO1DR5eo33Rfp6+shEedlQfk1uGhTU5JAUh3ZRvv/X7m5ungnJ5Ckhg9Kg8Xv1YX7
1FpmxrF+o3bpI5zInBDSXKSG7rzID3BeDtufEOYpuXZ6aSt3YSyW2Nga/FcMPNq3PKJI+Kd3GPnx
l1sZTk1dzOENtYqXY1FRmY3SeFRU/np4e6UGr9qF4gNN6dKhzarj02r2H25Iyvb1zeKJTnU16R8q
GtI4nUzkbwWX82GfQD7RbpTekvCF8eO/XQN+aXqIjMhl8p7lzuTo67a9X30mmwAYAANgAAyAATAA
BsAAGAADYAAMgAEwAAbAABgAA2AADIABMAAGwAAYAANgAAyAATAABsAAGAADYAAMgAEwAAbAABgA
A2AADIABMAAGwAAYAANgAAyAATAABsAAGAADYCVg/wEO+d3R
----END CUT----

I was told that the SQL version is different, which is causing the error and that I would need to remove the "SET SQL_MODE" from the database back up. However, when I try to do so I can't find it when I open it in Wordpad as the .sql code is really strange and just filled with symbols like this:

Code:
>ƒÃƒÂ±ÃƒÂ±Ã‚°{EØ}

Anyone have any idea or suggestions? Any help would be greatly appreciated.
 
Back
Top