Difference between revisions of "Talk:13 November 2006"

From Organic Design wiki
(I thought that the database was locked during the dump...?)
(mysqldump does not lock)
 
Line 1: Line 1:
 
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. --[[User:Rob|Rob]] 09:53, 13 Nov 2006 (NZDT)
 
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. --[[User:Rob|Rob]] 09:53, 13 Nov 2006 (NZDT)
 
:I thought that the database was locked during the dump...?
 
: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.

Latest revision as of 20:59, 12 November 2006

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.