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.
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.
So... I tried guessing that the file I want - which is for a table
called 'attractions' in the database 'aptguserdb' - might be at
data/aptguserdb/attractions.myd (and .myi for the index), but when I
try the myisamchk command with the full path to there I get 'file
does not exist'.
I'm stumped! How exactly do I go about this?
Highway 57 Web Development -- http://highway57.co.uk/
Despite the high cost of living, it remains very popular.