Talk:13 November 2006

From Organic Design wiki
Revision as of 20:59, 12 November 2006 by Rob (talk | contribs) (mysqldump does not lock)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Issue where a hot backup is taken from an on-line mysql database: If updates happen while the mysqldump is in progress it is possible that the resulting data file will not be able to be loaded back in. Not sure how to solve this one with mysql. --Rob 09:53, 13 Nov 2006 (NZDT)

I thought that the database was locked during the dump...?
Not unless you lock it. That's the problem with mysqldump. You can imagine how bad that can be with a large database.