Make MySQL Sync Automaticly.

Hi guys i am back and now i think i found a way of how i can have two dolphin sites using the same login system but of course it needs MySQL to Sync two databases and certain tables. I have found a way to do it manally in PHPMyAdmin but the only issue is i rather not sit there to click sync databases every hour.

So i was wondering if you guys know how to automaticly sync the databases togeather.

Thanks in advance (Excuse the spelling need to get to work now i be back soon waiting for you answers :)    ).

I think something like mysql replication. Not enough knowledge about it. You could search the web and see if it helps.

a couple of things here, since presumably you would not sync all tables, you are going to need to get a bash script written that would communicate with mysql, and sync up the tables and only the tables that you would desire to have synced. 

if you want to have two dolphin installs use the same database then just set the database connection string on both of them to the same database. 

but yeah, this would require some customization, and most likely IMHO, more headache than its worth. 

It's worth the headache to be honest. A bash Script not 100% sure what you are on about, but i look it up.

I will look it up @Prashank25 

Thanks for the help and advice any other suggestions would be lovely :).