Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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)

Thanks

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.