Answer the question
In order to leave comments, you need to log in
Mysql Backup Innodb, how to correct?
Is it enough to backup mysql database with this command?
mysqldump -uUSER -pPASSWORD database --default-character-set=utf8 > dump.sql
FLUSH TABLES WITH READ LOCK;
? Answer the question
In order to leave comments, you need to log in
Let's throw some more useful links here, shall we?
www.percona.com/software/percona-xtrabackup
Enough. You may not flush. If from a replica - you can generally make a binary backup - restore faster.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question