up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
0% accept rate
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
feedback

1 Answer

up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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