Hi Alex,
I've used this method to start a replication slave without using MySQLdump to
get the data from one machine to another.
Option 1 works for sure,
Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is
changed while you are copying, you get a broken file on the other
| |
+++---+--+--
---+---+-+--++--+---
-+-+
I dont understand why MySQL doesnt use the pageId_site_date index.
Maybe someone here can explain this issue to me or know a solution?
Thank you very much,
Michaël de Groot