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
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
thank you....i'll post the results once i implemented them
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
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...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.