Steve Ruby wrote:
>
> I haven't been able to get CHECK TABLE to work in win version
> of mysql since I started trying it (3.23.18 I believe)
>
> right now here is what happens. For a simple table with no
> data, mysql never returns from check table. The following
> commands in mysql 3.23.23 win32 never return in the
> mysql monitor (mysql.exe) the process list looks like
>
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
> | Id | User | Host | db | Command | Time | State |
> Info |
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
> | 1 | sruby | localhost | testdb | Query | 111 | NULL | check table
> testtable |
> | 2 | sruby | localhost | NULL | Query | 0 | NULL | show
> processlist |
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
>
> create database testdb;
> use testdb;
> create table testtable (a int);
> check table testtable;
>
> I am testing this on a smaller table because I have
> a large table full of data when I run check table on
> it mysqld-nt instantly pops up dr watson. and the server
> crashes. myisamchk on the same table works fine.
Looks like a there is something wrong either with your NT installation or with
NT libriaries or our NT binaries in general - on my Linux machine the above test
worked fine. Can you send us the table that CHECK TABLE breaks on?
--
Sasha Pachev
+------------------------------------------------------------------+
| ____ __ _____ _____ ___ http://www.mysql.com |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
