I have a mysql database that is constantly being updated throughout the day. I want to take a copy of the database several times a day as a backup and I want to send a copy of the database to a second server together with the backup copy so a script I am currently using on the second server can access the database that has been transferred.
The mysql database is about 4Mb and growing but I do not expect it to exceed 100Mb in the future.
The two servers are both dedicated.
At the moment I manually go into the first server copy the database to my pc as a text file and then upload it through the script on the second server and I want to automate this process between the two servers.
26 freelancers estão ofertando em média $144 para este trabalho
I have a script designed to do this already. (PHP, of course) I can have it sent to you immediately, or for a couple dollars more (only $10), I can install it myself.
i can set you up with mysql replication for a given database or i can do what you had in mind, periodictly export the database and upload it to the other side. Both ways are possible. let me know when i start :)