Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 have a case like this:

  • I have 2 database on 1 server, say it db1 and db2
  • db2 will be a copy of db1
  • data from db1 copied automatically to db2
  • data from db2 will not sync with db1 (db2 just a test database)

Any idea's to accomplish this? database can't be restart since it crucial (which editing my.cnf solution probably doesn't fit in this situation)


share|improve this question
Do you need this to be copied update by update or is "once a day" or something ok? – Jaydee Nov 22 '11 at 9:15

Take dump of database from db1 and restore it to db2. write a script to automate it and run it from cron according to interval you have set.

share|improve this answer

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.