Using Replication
From Hashmysql
Setting up Replication
This link should cover pretty much everything you need to know:
http://dev.mysql.com/doc/mysql/en/replication-howto.html
Setting up Replication with just one database
Modify the `GRANT REPLICATION SLAVE' command like this:
GRANT REPLICATION SLAVE ON db_to_replicate@* [...]
and make sure you have included the following option in the slave's my.cnf:
replicate-do-db=db_to_replicate
