MySQL Forums
Forum List  »  Replication

Re: 1-way Replication and PHP4
Posted by: Ramon Sosa Reyes
Date: August 17, 2005 10:00AM

To test if everything is working I personally use phpmyadmin, because is written in php can give a better approach about what is happening every time when i run a sql query.

Check in both servers if the table are innodb...
By the other hand the '' value make me to suppose that is an autonumeric field
$sql = "INSERT INTO test.database VALUE ('','hello')";

I recommend to you that don't use autonumeric field if must be replicated instead use the exactly value:
$id=next_id();
$sql = "INSERT INTO test.database VALUE ('$id','hello')";

Options: ReplyQuote


Subject
Views
Written By
Posted
2706
August 06, 2005 10:50AM
Re: 1-way Replication and PHP4
2017
August 17, 2005 10:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.