30 Oct
2008
30 Oct
'08
3:43 p.m.
On Thu, Oct 30, 2008 at 6:22 AM, Karanbir Singh mail-lists@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.