|List:||General Discussion||« Previous MessageNext Message »|
|From:||gclark||Date:||June 4 2006 10:45pm|
|Subject:||Re: myisamchk (was: name 'Szczech' returns more rows then |
|View as plain text|
> 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.