Re: Upgrading to 5.0.15 - Gary Richardson - com.mysql.lists.mysql

14 messages in com.mysql.lists.mysqlRe: Upgrading to 5.0.15

From	Sent On	Attachments
Robert DiFalco	27 Dec 2005 15:32
Tripp Bishop	27 Dec 2005 16:42
Gleb Paharenko	28 Dec 2005 05:03
Gary Richardson	28 Dec 2005 08:09
Christian Meisinger	30 Dec 2005 03:38
Gary Richardson	30 Dec 2005 07:55
Tripp Bishop	03 Jan 2006 15:44
emie...@micron.com	04 Jan 2006 06:24
Tripp Bishop	04 Jan 2006 10:00
emie...@micron.com	04 Jan 2006 11:29
Tripp Bishop	04 Jan 2006 12:01
Imran Chaudhry	05 Jan 2006 05:53
Kyle	05 Jan 2006 18:50
Gleb Paharenko	09 Jan 2006 06:02

Subject:	Re: Upgrading to 5.0.15
From:	Gary Richardson (gary...@gmail.com)
Date:	12/30/2005 07:55:56 AM
List:	com.mysql.lists.mysql

Did you try to run OPTIMIZE TABLE, REPAIR TABLE or ALTER TABLE on those tables? If you run an ALTER TABLE table_name TYPE=old_type (be sure to replace old_type with whatever the table currently is), it should rebuild the table.

Check the docs on mysql.com, there are a bunch of pages about upgrading between version. On possible probablem you could be facing in change in how whitespace is handled in indexes.

On 12/30/05, Christian Meisinger <c.me...@livingliquid.com> wrote:

Gary Richardson wrote:

We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a script that went through and optimized all tables with keys on text/varchar and char fields.

We're also slowly ALTERing innodb tables to get them into the new compact format.

i tryed to update from 4.1.15 to 5.0.17.

it was a disaster...

many varchar columns showed corrupted data after the update. can i do anything in mysql 4.1.15 to make the update work or is my only solution a complete dump and insert?

best regards chris