[CentOS] mysql 4 > 5 export import issue

Bart Schaefer barton.schaefer at gmail.com
Thu Oct 30 14:43:21 UTC 2008

On Thu, Oct 30, 2008 at 6:22 AM, Karanbir Singh <mail-lists at karan.org> wrote:
> in other news, you dont need to dump + reload when you move from mysql-4 to
> mysql-5, just service mysqld stop; yum update mysql\*;
> /usr/bin/mysql_upgrade ; service mysqld start

Theoretically true, but if you ask MySQL.com support they'll tell you
that a dump and restore is advisable.  It all depends on which
features you were using.  As just one example, if you were relying on
some of the previous auto-update semantics of timestamp columns,
you'll need to alter all the corresponding table definitions manually;
the upgrade process won't do it.

More information about the CentOS mailing list