Sunday, July 16, 2006

Copying MySQL Tables

I really find this one liner very handy when copying MySQL tables between different hosts.

2 comments:

Anonymous said...

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 -"

-- rylin

Frank said...

Rylin,

Thank you for pointing that out.

Frank