Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible?
or does the replication slave have to replicate everything written to all dbs after setting up the initial Master Binary Log Coordinates?

if so, what is the best way to backup a single database assuming a lot of writes is going on the master?


Use the replicate-do-db setting, and note that replication is not the same as a backup... TRUNCATE TABLE very_important or UPDATE credit_cards SET number='whoops' will replicate across and delete everything on the slave as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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