I’ve got a big database and mysqldumpIng it takes tooo long:-)
I played with tar and rsync and it seems to play well. But Im lacking experience. All I did was a “Flush tables with read lock” and doing a tar/rsync. In the long run I would prefer rsync. But Im not sure, if it is a bad idea.
Are there some experiences. Would you recommend something else for a binary backup? AFAIK no problems with MyISAM-Engine, but Im unsure regarding innodb-Engine.
Any advice?