List:General Discussion« Previous MessageNext Message »
From:Steve Ruby Date:August 2 1999 10:49pm
Subject:isamchk -r without shutdown
View as plain text  

Although crude it is the following sequence going
to hurt any data

mysqladmin flush-tables

cp mydata/dbname /tmp

isamchk -r /tmp/dbname/*.ism

mysqladmin flush-tables


this table is not likely to have many updates (unless i make them)
if the files have not been modified since I copied them out
can I replace the files in the data directory with the repaired
ones?

basicaly I want to know if I can repair an isam table without
shutting down the db server? under any circumstances where
the db in question will only be read from while the repair is
in progress.


Thanks
Steve


Thread
isamchk -r without shutdownSteve Ruby3 Aug
  • isamchk -r without shutdownMichael Widenius3 Aug