automatic replication

2003-12-30 Thread Robert Mena
Hi, I am currently using the replication function of my mysql server (3.23.58) to replicate one database. Since I host others I'd like to know if there is a way to automatically replicate a database. I.e as soon as a use issues a mysqladmin create it is propagated to the slaves. Any tips ? __

Autoincrement : how does it work / how to reset it

2003-01-31 Thread Robert Mena
Hi, I have been using autoincrement fields for some time but was wondering how does it work in some "special" situations. Ex. suppose I have an autoincrement field called num and the last one has value of 10. I delete the last on and insert a new one. Which value will it have ? 10 or 11 I read