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
upgradin
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
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.
On 12/28/05, Gleb Paharenko <[EMAIL PROTECTED]> wro
Hello.
Manual recommends to perform an upgrade step by step. So
I suggest you to move to 4.1 at first. When you said 'tablespace'
have you meant that you're using InnoDB tables? I'm not sure about
them, check the change logs to find out any incompatible changes. In
case of MyISAM,very often
