----- Original Message ----- > From: "kalin m" <ka...@el.net> > > thanks. it took about 15 hrs. but right now everything seems ok. does > the check last as long as the repair?
No, a check (myisamcheck -c or "check table" in sql) is a read operation that verifies structures, pointers and such but makes no changes. A repair (myisamcheck -r or "repair table" in sql) will both run a check, and if errors are found, will make a copy of the table with the data it manages to salvage. That means both reading and writing roughly the same amount of data that is in your table already, and on the same disk to boot - that's what takes so long :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
