I'm pretty sure that will work fine. Just be sure that MySQL isn't
running when you alter the files.
FYI - this is the same process the mysqlhotcopy script uses for making
backups. Instead of dumping SQL commands, it just makes copies of the
mysql /data directory.
alex
jon wrote:
> Hey folks...
>
> We managed to hose a couple of very large (< 2 gig) tables on our
> mysql server... but rebuilding 'em on that machine will probably bring
> down the box for a few hours...
>
> So... does anyone know if I can move the .myi or .myd files off the
> server, repair them, and move 'em back? Will that work?
>
> -- jon
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)