Replication pointers

[Theo Viset]

Hiall,

I want to execute an sql script that creates my database, my user, the replication user, execute all grant statements for connections and all replication statements for a daisy chained database (A -> B -> A) and fill the new database with initial data.

I ran into a problem with the master/slave file pointers, which I had to set manually quite often. Is there a way to create this database and be sure that the pointers are always the same? Now I had to check the 'SHOW MASTER STATUS' and set the pointer accordingly with the "CHANGE MASTER TO..." statement.

Now I created a database, locked the tables when I set the pointers, and tarred this file as my initial database. However, then I always need to have this tar as a database and change the database when I need to update initial data, while I want to be able to create a script to build the database in stead.

Any suggestions?

Greetz Theo