Hi Luke,
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I assume you mean 'mysqldump'.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
When does the
Hi,
I think there is another usable method to backup databases in MySQL.
And that is using a slave server, (that can be running in the same
server),
and when backuping up the databases you do (in the slave):
STOP SLAVE; -- This will stop the replication
-- Now
Hi Luke,
Like most backup systems, there is no window unless you are locking the
table/database. If the record has been read and passed out to mysqldump,
any further updates will not be included until the next backup.
The only way to ensure you get complete referential integrity is to stop
any ap
