Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

[gclark]

> At 14:02 +0300 1/6/06, Remo Tex wrote:
>>If you change the character set when running MySQL, you must run
>>myisamchk -r -q --set-collation=collation_name  on all MyISAM tables.
>
> Hi
>
> My problem isn't quite the same as the original poster's, but I
> suspect the solution may be the same. However, I'm having trouble
> running the myisamchk command.
>
> I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it
> won't let me get beyond a certain point in the file structure to find
> exactly where the files are. I can 'drill down' as far as the mysql
> directory, which has the promisingly-named data directory inside it.
> However 'cd data' tells me I don't have permission... but 'sudo cd
> data' simply repeats the same directory! I can't seem to get into
> data at all.
>
You must have the server stopped.
You must be logged in as root or mysql.