up one level
---
2015-04-30

One mysqldump per DB vs One mysqldump for All DBs

note: originally published 2012-10-08 at a different domain name and url.

the question is, is it better to have one mysqldump for all databases for your nightly and/or weekly backup? or better to have multiple mysqldumps nightly, one for each database? I think the answer lies in whether you want to spend more time setting up the backup scripts, or whether you want to spend more time separating out the one database’s data at the time when a restoration is needed.


[2019 edit: Moved to: https://i̶n̶v̶e̶s̶t̶o̶r̶w̶o̶r̶k̶e̶r̶.̶c̶o̶m̶/2015/... .html.]