Links database rows

[globex]

Is there a way to have a row from one database table to be synchronized with a table in a row of a different database. So that when one updates, the other automatically does the same.

 

Thanks,

- globex

[DanDaBeginner]

yes.. if youre using InnoDB you can use transaction if not then youre gonna have to manually coded it, if the other one fails then erase the first update..

[fenway]

I don't know what you mean by syncrhonized?

[globex]

I have IPB installed. When someone registers in IPB it adds a user to the ibf_members table. I want that user information automatically copied to another database I have setup for a different service.

[fenway]

That's going to be rather complicated, especially across databases... you may want to look into federated tables.

[Snooble]

it shouldn't be hard at all. I know almost nothing about MySQL.

 

But, goto the registration page, find where it POST's the form to, keep searching till you find the SQL query and underneath write it INSERTing the same variables to another db?

 

Snooble

[fenway]

it shouldn't be hard at all. I know almost nothing about MySQL.

 

But, goto the registration page, find where it POST's the form to, keep searching till you find the SQL query and underneath write it INSERTing the same variables to another db?

 

Snooble

 

It sounded like the poster wanted a long-term solution; I guess you could find every single reference to that table (insert, update, delete, etc.) and tinker with them, but good luck when IPB issues an update and you have to start all over again.