Sqldump.sql

[Dorvita]

Hi there hope this finds you well.Ive just installed the prog with no probs all pretty straight forward until I tried to restore from the SQLdump and all hell broke loose..lol.. heres the error message Im getting..

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:02:18

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:02:38

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

W‹|$3À3Ò…ÿv)SV‹t$¾2ÁàÁ‹Èá

Error occured at:2007-11-10 16:02:58

Line no.:4756

Error Code: 1064 – 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 'MZ

W‹|$3À3Ò…ÿv)SV‹t$¾2ÁàÁ‹Èá' at line 1

Query:

MZ

Error occured at:2007-11-10 16:03:09

Line no.:207

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:04:18

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:04:42

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:05:17

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:07:29

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:10:00

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

CREATE TEMPORARY TABLE tmp_db LIKE db

Error occured at:2007-11-10 16:22:52

Line no.:7

Error Code: 1051 – Unknown table 'db'

Query:

MZ

Error occured at:2007-11-10 16:23:30

Line no.:597

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

Error occured at:2007-11-10 16:26:48

Line no.:597

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

Error occured at:2007-11-10 16:28:38

Line no.:597

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

Error occured at:2007-11-10 16:28:48

Line no.:597

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

Error occured at:2007-11-10 16:34:33

Line no.:597

Error Code: 1064 – 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 'MZ' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:34:53

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:38:36

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Query:

MZ

 ,

W

Error occured at:2007-11-10 16:42:18

Line no.:4760

Error Code: 1064 – 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 'MZ

 ,

W' at line 1

Ive tried a few different things and tried to search for an answer but no joy Im affraid.Id be ever so greatful for any help or advice you can offer..Im dying to get this up and running but Im stuck on this little thing…

Hope you all have a lovely weekend..

Dor.x

[peterlaursen]

1) Please tell the exact program (SQLyog) version used for the import!

2) Was the dump created with the same SQLyog version? or another version or another program?

3) Tell the MySQL server version(s) from where you export and import (both). Note that a dump created from MySQL 4.1 and higher is not compatible with 4.0 and lower! There are encoding issues (4.0 do not support Unicode) as well as the CREATE TABLE statement is slightly different. The 'weird' characters seem to indicate that this is the situation! What charset did you select for the export (this option is only supported with the 'scheduled backup' feature of ENTERPRISE version and only with recent versions?

4) How do you connect? direct, HTTP-tunnel or SHH-tunnel? the 'temporary table' issue seems to indicate HTTP?

4) Could you please provide an example of such dump that fails to restore? (you cannot attach .sql files here – rename to .txt or better zip before attaching!). You can create a ticket if you want privacy.

[DonQuichote]

MZ are the first two characters of an .EXE file. Are you sure it is a database dump?

[Author]

Posts