Hello, i have 2 questions about Replication.
1) I managed to make one slave and one master. The replication works fine and it updates only one table from one database (cause of the replicate-do-table=db.table1). The first question is can I tell mysql that table1 from master to be named table2 on slave? I already have another table1 and I dont want to overwrite it. 2) As far as I read I can have as many slaves as I want and one master. Can I have the opposite? Imagine the follow scenario: I have 3 Shops with 3 Database (same structure) and they all contain a table "CUSTOMERS". I want to put all those customers from 3 shops to a central database. So, I was thinking to inverse the master/slave logic and backup each shop to the slave computer. Thats why I need to change the name of table. Because i want to backup customers of first shop to CUSTOMERS1, customers of second shop to CUSTOMERS2 etc etc. Your comments are welcomed. Thanks
