Re: Database upgrade character column sizes may have changed
Quote
I can copy the database files over to the new server and "mysql_upgrade" but it produces a lot of warnings in mysqld.err.
Not sound at all; that will trip over all manner of version-to-version incompatibilities, such as some of those listed at
http://www.artfulsoftware.com/infotree/mysql_incompat.html.
Sound method is to mysqldump on the old data, bac kup the old data, install the new server, run mysql_upgrade, then run the dump script.
PB
Subject
Written By
Posted
Re: Database upgrade character column sizes may have changed
January 07, 2011 03:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.