Re: mysql 3.23.58

At 9:18 +0930 8/10/06, Paul Coldrey wrote:
>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.

Use the --compatible=mysql323 option for mysqldump to disable the
CREATE TABLE clauses that won't work in MySQL 3.23.


>
>
>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]


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

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