Error Sending Me Mad ! Please Any Help

[peterlaursen]

What are the MySQL server versions involved? Form which version do you exxprot and where do you import.

This ” …ENGINE=MyISAM DEFAULT CHARSET=latin1″ is generated by MySQL 4.1 and higher but is not understood by MySQL 4.0 and lower. That could be the issue! If that is then there are two options:

1) simply remove the above phrase in an editor

2) use our latest beta. It generates a 'backwards compatible backup'.

If that is not the issue, we will need more details. A small test case, preferably. Detailed information of program versions (SQLyog, MySQL servers)

[rawilly]

peterlaursen wrote on Dec 7 2006, 04:43 AM:

What are the MySQL server versions involved? Form which version do you exxprot and where do you import.

This ” …ENGINE=MyISAM DEFAULT CHARSET=latin1″ is generated by MySQL 4.1 and higher but is not understood by MySQL 4.0 and lower. That could be the issue! If that is then there are two options:

1) simply remove the above phrase in an editor

2) use our latest beta. It generates a 'backwards compatible backup'.

If that is not the issue, we will need more details. A small test case, preferably. Detailed information of program versions (SQLyog, MySQL servers)

hi thx for answer my sql is 4.1 just checked i will now try the 2 options and will post results

[rawilly]

rawilly wrote on Dec 7 2006, 10:45 AM:

hi thx for answer my sql is 4.1 just checked i will now try the 2 options and will post results

hi ive just downloaded beta 521 community edition and tried it again but same error also then i tried removing the line you stated but alas same error so at moment i am using my sql 4.1 and sqlyog 5.21 i downloaded the beta 521 from the binaries edition or should it be the one in source community edition many thanks for your help so far

[peterlaursen]

pooohhhh …. That was a long sentence without a aingle punctuation 😀

Please provide a small test case: a dump of a single table with a few rows of data only. We need getting oor hands on some data. TRey are better than words!

And pleasse confirm: both sorce and target servers are 4.1.x ??

[rawilly]

😀 😀 😀 found error it was in another file i had put an extra , many thanks for taking interest its a great tool 😀 😀 😀

[Author]

Posts