While a good one, it still has to rebuild the index on the remote server, which might incur a bit of downtime/unavailability. This is why I love myisam from time to time (though definitely not ALL the time!): tar -cf - /path/to/db/table.* | ssh username@remotehost "cd / && tar -xf -"
While a good one, it still has to rebuild the index on the remote server, which might incur a bit of downtime/unavailability.
ReplyDeleteThis is why I love myisam from time to time (though definitely not ALL the time!):
tar -cf - /path/to/db/table.* | ssh username@remotehost "cd / && tar -xf -"
-- rylin
Rylin,
ReplyDeleteThank you for pointing that out.
Frank