Assuming that your goal is to migrate an old database, perhaps the things that will bite you the fastest: * TYPE=MyISAM --> ENGINE=MyISAM. * CHARACTER SETs -- no concept in until 4.1. Use DEFAULT CHARACTER SET=latin1 for now. Later you can figure out how to migrate to utf8. (Note that 5.5 defaults to utf8, which is likely to dislike your bytes.)
I would dump the data, then import into 5.x. Upgrading step by step would be quite tedious. Migration to InnoDB is also desirable, but not mandatory. > -----Original Message----- > From: Nagaraj S [mailto:nagaraj....@gmail.com] > Sent: Thursday, August 22, 2013 12:16 AM > To: shawn green > Cc: mysql@lists.mysql.com > Subject: Re: MySQL version 3.23 to 5.x features > > wow it really helped me a lot. I really thank Shawn,Dale Jesper for there > inputs > > > On Wed, Aug 21, 2013 at 7:13 PM, shawn green > <shawn.l.gr...@oracle.com>wrote: > > > Hello Naga, > > > > > > On 8/21/2013 6:45 AM, Nagaraj S wrote: > > > >> Hello, > >> > >> Can anyone share the features/comparison from MySQL version 3.23 to > >> 5.x in single document? I can get from Google, however I have to > >> navigate different pages/sites, if it is in single document that will > >> be useful to see the overview of mysql features > >> > >> > > While not exactly just one single page for all changes, there is a > > single page of the fine manual within each new major version that > > describes the big features that are new or changed within that version. > > > > http://dev.mysql.com/doc/**refman/5.0/en/mysql-nutshell.**html<http:// > > dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html> > > http://dev.mysql.com/doc/**refman/5.1/en/mysql-nutshell.**html<http:// > > dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html> > > http://dev.mysql.com/doc/**refman/5.5/en/mysql-nutshell.**html<http:// > > dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html> > > http://dev.mysql.com/doc/**refman/5.6/en/mysql-nutshell.**html<http:// > > dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html> > > > > Unfortunately, to learn what we changed between 3.23 -> 4.0 or between > > 4.0 > > -> 4.1, you are going to need to review the change logs > > http://dev.mysql.com/doc/**refman/4.1/en/news.html<http://dev.mysql.co > > m/doc/refman/4.1/en/news.html> > > > > > > from > > http://dev.mysql.com/doc/**refman/4.1/en/index.html<http://dev.mysql.c > > om/doc/refman/4.1/en/index.html> > > ==== > > This manual describes features that are not included in every edition > > of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be > > included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed > to you. > > ==== > > > > > > I can pretty much summarize the deficiencies in 3.23 like this > > * No InnoDB, Archive, CSV, Federated, or Blackhole storage engines > > * No table partitioning > > * No Views > > * No Stored Procedures or Stored Functions > > * No Triggers > > * No Events > > * Severe scalability limits (won't run as fast with reasonably > > concurrent loads even on great hardware as later versions) > > * Completely out of print (unpublished) and unsupported. > > * Missing literally thousands of bug fixes and performance > > improvements > > > > > > Any new project should be starting out with 5.6. Any production > > server should be on 5.5 or 5.6 by now or migrating soon. It is also a > > fairly safe bet that if you are still operating a 3.23 instance of > > MySQL that it is also time to upgrade your hardware. > > > > Regards, > > -- > > Shawn Green > > MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware > > and Software, Engineered to Work Together. > > Office: Blountville, TN > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
