refreshing 2 databases, according to time.

[gopi17]

heyy, as the title says, i need help regarding this issue...
okay, the thing is i have two databases with the same number of fields.
i need a function that runs over time, checking and maintaining the data inside both

database A takes data from my company server, database B should copy and keep track of the data..to make sure everything is the same.

can u guys guide me...i have created the 2 databases, i just need some guide on how to tally both the data...

thank you

[cereal]

This is called database replication, you can apply different solutions, if you are using MySQL then read these:

http://dev.mysql.com/doc/refman/5.0/en/replication.html
http://www.howtoforge.com/mysql_database_replication

bye

[gopi17]

thank you....i'll post the results once i implemented them

[gopi17]

hey...so, i did some testing on database replication and synchronization...and my database isn't changing....is there any other way to sync them during real time?

http://setenforce.com/mysql/mysql+backup.php

http://blog.evandavey.com/2008/05/how-to-setup-mysql-replication-a-simple-guide.html

[gopi17]

i manage to do it...thank you....for those of you who like to know...i'll post the link right below

http://www.phpclasses.org/package/4790-PHP-Synchronize-two-MySQL-databases.html

good luck guys...