Re: mysql 3.23.58
"Pritesh Chandra" <[email protected]> Thu, 10 Aug 2006 13:27:43 +1200
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <020a01c6bc1c$2ea5ecd0$c901000a@pritesh> |
Thanks Pritesh Chandra, 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. ----- Original Message ----- From: "Paul DuBois" <[email protected]> To: "Paul Coldrey" <[email protected]>; "Pritesh Chandra" <[email protected]> Cc: <[email protected]> Sent: Thursday, August 10, 2006 11:51 AM Subject: 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]