--replicate-do-table usage example

2004-03-17 Thread Andrew Pasetti
I'm a bit new to mysql replication. Can someone please explain how to implement the --replicate-do-table start up option? Replication is up and running, but I would like to limit the replication to just two specific tables in one database only. Using mysql v4.0.18 Linux/x86 Your advice will be g

how to move a database to a new server?

2001-07-23 Thread Andrew Pasetti
Can someone please recommend the easiest way to transfer a database (with data) from one server to another? Here's the server info: Existing server: Linux 2.2.14-5.0 running mysql 3.23.10-alpha New server: Linux 2.2.14-5.0 running mysql 3.23.32 Thank you. Your feedback will be greatly app