PDA

View Full Version : sync a data base


ForgotenDynasty
08-15-2008, 06:36 PM
ok i have 1 bulletin forum that already has members in the data base

now i am soon to comeout with a new forum

if i Inject all the members from the first site in to the second (keeping the Member numbers)

Can i Rig it so that when a member registers on 1 site the SQL quarry is sent to Both sites?

creating members on both sites

Dismounted
08-16-2008, 11:44 AM
You can create a hook to hook into the registration process - in there, you can run any PHP code you want.

ForgotenDynasty
08-16-2008, 10:24 PM
im kind of new to php and am no where near coding something that advanced lol.

Since both SQL are on the same hosting (so it will be local host)i was kind of hoping someone would say connect to both databases by putting this in your Config.php
then add this to register.php to send the quarry to both MySQLs

Dismounted
08-19-2008, 09:01 AM
I'm afraid keeping two tables in sync is not that easy. You have to account for changes, deletions, etc. as well.