
June 26th, 2003, 08:11 PM
|
|
|
|
Join Date: Apr 2007
Location: WI
Posts: 247
Time spent in forums: < 1 sec
Reputation Power: 2
|
|
|
mysql sync tools
Hi there, anohter odd one.
I have a bunch of mysql dbs on my hosting.
because it is not my own server I do not have full control - obviously!
I want to use this as a master to update the mysql server on my own server for back up and extra development stuff.
I figure I could write a php script that runs in cron to do this, simply feed it a bunch of database names (I can;t get a list I don't think) and just use php to read the database and drop the local one, then create the database locally and fill with the info from the remote one. That is possible right?
anyway, before I started it I wondered if any bright spark had done this before to safe myself the hassle.
so, anyone know if any tools to do this?
I know you can sync two servers through mysql itself but I can't do that here as I do not have that level of control.
also if anyone can think of any stumbling points on this, let me know.
Thanks
|