At 9:01 PM -0600 2/16/08, Hayden Livingston wrote:
We're trying to upgrade from 4.1.20 to 5.0.54. The problem is running
mysql_upgrade. It's turning out to be that about 70% of our tables
(over 800GB) are being needing repair.
The question is, will it be possible to "get by" without upgrading?
Eventually we'll get to it, but will data be served from these tables
if we don't? A lot of our tables DO have TEXT indexes, which
apparently have gone under some padding related incompatible changes,
what does this really mean, these tables can't be read or they will be
inefficient?
The server should be able to read them (if it couldn't, mysql_upgrade,
which uses mysqlcheck, a client, couldn't tell the server to repair
them!). But until those TEXT indexes are rebuilt, you might get
incorrect results for some queries.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
