Thanks for that, it makes sense. I’m not sure I feel that comfortable backing up a single big DB that way though, having to go through that process for every table on restore. The database I have in mind is <2GB and I have been looking at msqldump --single-transaction to handle getting a valid backup from it. Am I correct in thinking this is probably the most straight forward way of doing it and that xtrabackup is maybe a better option if I were to be backing up all the DB’s on a server?