Pb with MySQL Replication
Posted: Wed Dec 04, 2002 6:35 am
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 ?
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 ?