Forum Moderators: phranque
I have 2 Mysql databases on 2 servers (1 inside / 1 outside a firewall - webserver)
Both servers (Linux) run apache, mysql and php.
On the inside server .. I will have a master mysql db with a php interface to view/modify it. After changes are done I want to export changes to the database outside the firewall on our webserver.
What is the best practice to do this? the export data. Export all database? Do it through php insert/ Update? Do sqldump and ftp the file (i need to do automatically)? Is there a way of just exporting changes and not the whole db?
thanks
frank
