Doing it via command line shouldn't take but a few minutes if a dump only takes just a minute. If it dies in the middle of the operation nothing gets hurt.

Optimizing the table actually writes out the table into a temp table (with no space in the middle.) When that space free copy is finished MySQL deletes the fragmented table and renames the temp in it's place.

If the operation dies in the middle the temp gets cleaned up and nothing happens.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]