Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to setup a development database such that it'll initially be a mirror of the database used in production. At fixed points during the day (maybe midnight or something) and/or manually, I want it to be sync'd once again with the production DB.

My goal is to have a database I can play and mess with, with no lasting consequences. I've looked at replication, and it doesn't seem to be a good fit for this scenario. See, what I thought initially is that I could set up a slave, dump it, do my work, then use the dump to revert it to its previous (pristine?) state, before syncing with the master. Repeat when needed. While I might be able to get away with this with relatively small DBs, 8 gigs worth of dumps tend to take a while to be generated and imported. Plus I'd like to be able to have something that will scale to several devs.

Any hints as to where I should look next?

share|improve this question

migrated from May 9 '11 at 12:35

This question came from our site for professional and enthusiast programmers.

@Neil Santos - Welcome! hope posted answers will help... please mark accepted answer. – CoderHawk May 13 '11 at 7:27
up vote 4 down vote accepted

You can look into MySQL snapshots using the file system. More details in this link. Snapshots are very quick to create, and can be rolled back to.

share|improve this answer
Thanks for the tip! – Neil Santos May 17 '11 at 11:37

For Oracle it's quite easy, a snapshot standby database would do the trick for you. Maybe Oracle will integrate this capability in mysql .... With 8GB databases, making a new copy should not give a lot of problems .... 15 minutes for a copy?

share|improve this answer
Thanks for the reply; I'll keep this in mind, if I find myself working with Oracle. :) – Neil Santos May 17 '11 at 11:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.