Server 1 has the mysql database and is constantly collecting data
currently 148.9 MiB (win2008 server with Appserv installed)
Server 2 has all php files and domain eg. [url removed, login to view]
Server 2 connects to server 1 for data on every page which causes a
massive delay in page load time
Resolving domain to server 1 is not an option.
What I want to do is great a new mysql database on Server 2 that syncs
daily from Server 1 automatically