Pb with MySQL Replication

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
steftar
Forum Newbie
Posts: 1
Joined: Wed Dec 04, 2002 6:35 am

Pb with MySQL Replication

Post 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 ?
Post Reply