Re: mysql 3.23.58

Hi Pritesh,

This doesn't look like a bug and so it really should have been sent to
one of the support lists rather than the bugs list. If you feel it is a
bug then you should provide a sample script that exposes the bug and
report it at http://bugs.mysql.com/.

Looks to me like a minor syntax change between 3.23 and 4.1. Perhaps the
ENGINE syntax appeared after 3.23 and if you replace this with
TYPE=MyISAM it might all work,.... I couldn't find any reference in the
manual to which version the ENGINE syntax started but as I recall TYPE
was the original syntax.

Cheers,

    Paul.


Pritesh Chandra wrote:
> I have mysql 4.1.16 loaded in one server and the other server has mysql 3.23.58
>
> when i do a mysqldump from 4.1.16 and try to load it on 3.23.58,
> i get this error You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1'
>
> i cant figure out what i am doing wrong.
>
> thanks
>
>  
> This email and any attachments may contain privileged and confidential information and are intended for the addressee only. If you have received this email in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this email has been sent to you in error. It is your responsibility to check this email and any attachments for viruses. No warranty is made that this material is free from any computer virus or any error. Any loss/damage incurred by using this material is not the sender's responsibility.
>
>   


-- 
Paul Coldrey
http://www.ensigma.com.au/



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]