E
E
Eugene2014-07-01 11:51:38
MySQL
Eugene, 2014-07-01 11:51:38

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

Type of tables innodb, or should be done before backup
FLUSH TABLES WITH READ LOCK;?
Backup is done from the slave of the replica.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Rpsl, 2014-07-01
@Rpsl

Let's throw some more useful links here, shall we?
www.percona.com/software/percona-xtrabackup

S
Sergey Petrikov, 2014-07-01
@RicoX

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 question

Ask a Question

731 491 924 answers to any question