Specializing in big data deployments using MySQL / NoSQL Solutions. Topics: [mysql tutorial] [database design] [mysql data types]
[mysql commands]
[mysql dump]
[database development] [mysql training] [mysql scalability] [mysql sharding] [mysql performance tuning]
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 -"
2 comments:
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
Rylin,
Thank you for pointing that out.
Frank
Post a Comment