setup development and live site

[prophoto]

Can you explain how you would setup a development site and a live site and keep them in sync, pushing out updates as needed? Obviously the live site would have constantly updated data which prevents copying then working on it and pushing it back to live.

 

[rob]

Try checking out "toad for mysql" which is free and has a compare and merge database schema feature
http://www.toadworld.com/m/freeware/552.aspx

Paid alternatives are :
http://www.red-gate.com/products/mysql/mysql-comparison-bundle/
http://www.navicat.com/products/navicat-for-mysql

 

[prophoto]

Not sure what happened but it seems to be fine, thanks.