Bonjour,
I have a table :
[11:09am] mysqldump -d cotations historique_AMS
# MySQL dump 8.16
#
# Host: localhostDatabase: cotations
#
# Server version3.23.45
#
# Table structure for table 'historique_AMS'
#
CREATE TABLE
BAUMEISTER Alexandre writes:
Bonjour,
I have a table :
[skip]
Any idea ?
Regards,
Alex.
There were some bug fixes with packed keys.
3.23.47 will soon be out and it would be fine if you could test your
case with it again.
--
Regards,
__ ___ ___ __
/ |/
Bonjour Richard,
RE Have you checked your table with myisamchk? Sounds like a corrupt
RE index to me.
I did check and repair table from mysql console.
And from the documentation :
CHECK TABLE only works on MyISAM tables. On MyISAM tables it's the
same thing as running myisamchk -m
Bonjour Sinisa,
SM There were some bug fixes with packed keys.
SM 3.23.47 will soon be out and it would be fine if you could test your
SM case with it again.
I tried to do
alter table historique_AMS PACK_KEYS=0;
But it did not correct the problem.
Then I wanted check if the
Bonjour,
BA But I forgot the -d ... and here is what I found : There are some
BA \r at the end of some symbols !
I corrected everything with one query :
mysql UPDATE historique_AMS set symbole=TRIM(TRAILING '\r' FROM symbole);
These '\r' may come from a program a colleague did.