Difference between revisions of "Talk:13 November 2006"
From Organic Design wiki
(''hot'' backup issues) |
(mysqldump does not lock) |
||
| (One intermediate revision by one other user not shown) | |||
| 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...? | ||
| + | ::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.
