rsync to copy some measurement data from one PC to the server.
Is it possible to load the new MyISAM tables without restarting the MySQL server?
Suppose you are moving a MyISAM table with the following characteristics:
You can move it to another folder without disturbing any other DB activity
Here is how
Step01) Create the Target Database on ServerB with this command
Step02) Copy the table to the
Run this rsync on ServerA
That's it. The table should be immediate registered in the information_schema without a restart. To verify that the rsync worked, login to mysql on ServerB and run this:
If you want to double check the rsync, run thi command on both
Both checksum values should be identical
Give it a Try !!!