Valcav
Customer
Situation: (I have currently 2 (web)servers (both linux))
Server1 has MySQL databaseA (gaa_phpbb3)
Server2 has MySQL databaseB (op_oldtdo) & a databaseC (op_newsite)
(gaa_phpbb3 & op_oldtdo are fictive names, just to show how the database-names +- look like...)
Server1 runs our current website. (which uses databaseA)
Server2 will run the new website. (which will use databaseC)
databaseB is for a intermediate step.
Problem: getting every data from databaseA into databaseB.
first time a complete copy of databaseA, after that, for example: every week (or every month), add new data from databaseA into databaseB.
Possible solution:
(been talking to my web-server-provider and they said at the end
"You may be able to have one that drops the database, on server 1. Then on server 2 it downloads that .sql and uploads it, but you would need to hire a developer to get that together. We do not go into much support on cron jobs. "
So if anyone can help me with this...
thanks
f you need more info, feel free to ask.
And I hope I explained it clear enough...
Server1 has MySQL databaseA (gaa_phpbb3)
Server2 has MySQL databaseB (op_oldtdo) & a databaseC (op_newsite)
(gaa_phpbb3 & op_oldtdo are fictive names, just to show how the database-names +- look like...)
Server1 runs our current website. (which uses databaseA)
Server2 will run the new website. (which will use databaseC)
databaseB is for a intermediate step.
Problem: getting every data from databaseA into databaseB.
first time a complete copy of databaseA, after that, for example: every week (or every month), add new data from databaseA into databaseB.
Possible solution:
(been talking to my web-server-provider and they said at the end

"You may be able to have one that drops the database, on server 1. Then on server 2 it downloads that .sql and uploads it, but you would need to hire a developer to get that together. We do not go into much support on cron jobs. "
So if anyone can help me with this...
thanks
f you need more info, feel free to ask.
And I hope I explained it clear enough...