RE: backup questions

2008-01-28 Thread Michaël de Groot
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

Question about index usage

2007-01-18 Thread Michaël de Groot
| | +++---+--+-- ---+---+-+--++--+--- -+-+ I don’t understand why MySQL doesn’t 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