I have two site one for static info about MUJ Alumni (http://mujalumni.in/muj2). It is also a wordpress site. The second one is a portal for our members (http://mujalumni.in/portal). It is also a wordpress site with buddypress support.
No, I am not thinking of having subdomain /subfolder. I am already managing that.
If you can provide your contact details, we can have a talk about this.
@danbp: Thanks for the support. I have checked HyperDB, But I think that it is not useful for our problem scenario.
@sharmavishal: Thanks for the support. I know that BP is saving extra profile data in xprofile tables and when user is updating his info that will be reflected in those xprofile tables only(these xprofile tables are in database named “wp_900”). I want to reflect those changes (updates) in one more table named “USER_data” which is in different database named “AlumniDB”. The AlumniDB tables store the data of single user in single row whereas xprofile table stores the data of single user in 35 rows (each row for each profile field.)
It will be helpful if you suggest some plugin for this work.
Okay I will try, getting some clue. But how will I maintain data consistency say user updates CITY information and same information must be reflected in the CITY field of the MySQL DB created by me.
By 2 separate DBs I mean that:
1. Earlier we were not using BuddyPress and had MySQl as backend DB.
2. We shifted to BuddyPress later on but maintaining MySQL DB as well for SignUp by the users.
Now the problem is when the user adds himself the records are saved in our MySQL DB but when the user updates his records the updated data goes and is saved in the BuddyPress DB.
How to replicate & sync the updated records in the BuddyPress DB to our MySQl DB (some 35 fields are getting updated and needs to be replicated in the MySQL DB)
