On Thu, Oct 30, 2008 at 6:22 AM, Karanbir Singh <[EMAIL PROTECTED]> 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. _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
