Connecting remote mysql database to local mysql databse? [migrated]
- by Shashank
I want to write a php code to be embedded in drupal7 module.
I want to call a procedure which can copy the newly generated data in local mysql database to the remote mysql database.
When data is inserted in tables 'A' of my local data base it should be copied to the specific table 'B' of the remote mysql server's database.
Table 'A' is on local host.
Table 'B' is on remote server.
insert data on 'A' - copied data in 'B'
Is this possible?
Thanks for the help.