Page 1 of 1

Pb with MySQL Replication

Posted: Wed Dec 04, 2002 6:35 am
by steftar
I 've made a replication between 2 same bases on 2 servers. When I use phpMyAdmin to make a query that works. If I use my php script the data are saved on the local server but are not replicate on the other server.

My script:

$link=mysql_connect('localhost','replicate','replicate');

mysql_select_db('client');

mysql_query("INSERT INTO `commande` (`NoBonLivraison`) VALUES ('1')");

mysql_close($link);

For my test the user 'replicate' have all the privileges

Do I forgotten a property in my connection ?
Why replication doesn't work ?