Never run isamchk with the server running.
Joan Vidal wrote:
> I can't believe MySQL is behaviouring that way and giving that kind of errors.
> I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
> all with the same results.
>
> Can anyone please help?
>
> Thx in advance,
> Joan
>
> The tests consists in:
> * creating a table,
> * to insert 2 registers,
> * to erase 1 register,
> * and... in this point of it annoys everything.
> TO PASS a ISAMCHK with option - r (to repair).
> Once I throw this, the table is in a error state.
> When I passed a SELECT count(*) gives 1 registry us,
> and if we happened a SELECT * says that this vacia to us.
>
> (To see results down)
>
>
>
>
> TEST:
>
> DROP TABLE prueba;
> CREATE TABLE prueba (id bigint not null,nom varchar(100));
> INSERT INTO prueba VALUES (1,'ONE');
> INSERT INTO prueba VALUES (2,'TWO');
> DELETE FROM prueba WHERE id<2;
> select * from prueba;
> select count(*) from prueba;
>
>
> Exit MySQL and run :
> isamchk -r /D3/mysql.tables/joan/prueba
>
>
> Mysql:
> select * from prueba;
> select count(*) from prueba;
>
>
>
>
>
>
>
>
>
> [root]# mysql test
> mysql> DROP TABLE prueba;
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> CREATE TABLE prueba (id bigint not null,nom varchar(100));
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> INSERT INTO prueba VALUES (1,'ONE');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> INSERT INTO prueba VALUES (2,'TWO');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> DELETE FROM prueba WHERE id<2;
> Query OK, 1 row affected (0.01 sec)
>
> mysql> select * from prueba;
> +----+------+
> | id | nom |
> +----+------+
> | 2 | TWO |
> +----+------+
> 1 row in set (0.00 sec)
>
> mysql> select count(*) from prueba;
> +----------+
> | count(*) |
> +----------+
> | 1 |
> +----------+
> 1 row in set (0.00 sec)
>
>
> [root]# isamchk -r prueba
> - recovering ISAM-table 'prueba.ISM'
> Data records: 1
>
>
>
> ANY RECORDS IN DATABASE,
> BUT count(*) is 1.
>
> [root]# mysql test
> mysql> select * from prueba;
> Empty set (0.00 sec)
>
> mysql> select count(*) from prueba;
> +----------+
> | count(*) |
> +----------+
> | 1 |
> +----------+
> 1 row in set (0.00 sec)
>
> mysql>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php