Re: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-21 Thread Gleb Paharenko
Hello. I suggest you to use 4.1.10 (in 4.1.8 was fixed a bug #6784, I haven't seen it in a changelist of 4.0.x branch). If myisamchk -r *.MYI, myisamchk -o *.MYI doesn't solve the problem, as the last chance, use USE_FRM mode of REPAIR command. But you may lose some information about the

Re: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-18 Thread Gleb Paharenko
Hello. Where can I download it See: http://downloads.mysql.com/archives.php We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18 Do you use official binaries? Sometimes after upgrade

RE: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-18 Thread Steven Roussey
See: http://downloads.mysql.com/archives.php Thank you. Nice link to have around. Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2). Do you have the same values for full-text parameters (ft_mit_word_len for example)? Not at first. I had noticed that not long after I sent

Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-17 Thread Steven Roussey
I have replaced one server with another, and the new one has everything new (RHEL 3, newest updates) and MySQL 4.0.23 (old one was RH9 and MySQL 4.0.18). We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18