MySQL Forums
Forum List  »  Backup

Re: MySQLdump Lock Table
Posted by: Micaela Fermani
Date: November 27, 2018 02:06AM

Hi Peter,
the backup command that we execute is:

mysqldump-u sa-p --single-transaction=TRUE --quick=TRUE mydatabase > mydatabase.sql;

The option--quick we added according to your instructions.

What we notice is that if during the backup operation there are commands of data alteration (insert update delete), our backup job does not end as long as such transactions are not completed.
Imagine is to get a consistent backup.
Furthermore, if during the backup process there are operations on the data, we note that the backup process queries the tables "flush table" mode.

The mysqldump can be executed and completed without interfering with user tasks?
The flush table is also a lock tables?

Mysql version we use is 5.6.40

Thank you for your support

Options: ReplyQuote


Subject
Views
Written By
Posted
1677
November 22, 2018 04:46AM
575
November 22, 2018 03:42PM
601
November 23, 2018 03:06AM
577
November 23, 2018 11:56AM
Re: MySQLdump Lock Table
623
November 27, 2018 02:06AM
540
November 27, 2018 12:14PM
500
December 04, 2018 03:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.