Fli
11-11-2014, 08:07 AM
Hello,
when syncing whole linux filesystem including mysql folders, in which circumstances i can endup with non working mysql backup?
Only when rsync reading data that are at that moment written (unfinished write)? If this corruption happen, can be this easilly fixed by mysql table repair function (it will delete corrupted row from table or such)?
Safe way is to stop mysql service and then do rsync.
when syncing whole linux filesystem including mysql folders, in which circumstances i can endup with non working mysql backup?
Only when rsync reading data that are at that moment written (unfinished write)? If this corruption happen, can be this easilly fixed by mysql table repair function (it will delete corrupted row from table or such)?
Safe way is to stop mysql service and then do rsync.