[rt-users] Mysql / 4.x to 5.x user with Rt3

sc2 at gmx.at sc2 at gmx.at
Sun Jun 10 08:44:25 EDT 2007


hello
i know this is not a mysql maillist but i think it has to do with rt3.
Should i do something else when i use mysql 5 instead of 4 (i used before)
Cause i cant dump now rt3 for backup cause of a failure on Attachments 
table.
The other tables are "repaird/upgrade" successfull

when i make check tables attachments, i get the information
rt3.Attachments | check | error    | Table upgrade required. Please do
"REPAIR TABLE `Attachments`" to fix it! |

when i do this, or  mysqlcheck --check-upgrade --all-databases --auto-repair
all is fine, he says tables repair but the table is still (after a new
check) not "Upgrade" all other tables are.

Cause of this , i cant dump the database, (he crash, with this failure)
any ideas (?) it is a InnoDB Format.

i forgot to wrote what happens after repair
mysql> REPAIR TABLE Attachments;
+-----------------+--------+----------+-----------------------------+
| Table           | Op     | Msg_type | Msg_text                    |
+-----------------+--------+----------+-----------------------------+
| rt3.Attachments | repair | status   | Table is already up to date |
+-----------------+--------+----------+-----------------------------+
1 row in set, 1 warning (6 min 30.36 sec)

thanks
friendly regards 




More information about the rt-users mailing list