I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess.
I did this out of hours but I was wondering how consistent the data will actually be after the move? Does mysql keep data in cache and also on disk or is everything that was in cache prior to the move lost?
Let me know if that doesnt make sense!
Thanks