MYSQL transfer and backup

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.

Hello. I will make a perl script that will create a backup of your database and upload it via FTP to your other server. This script can be set up to run by cron. I can do that for 80, but the system doesn't allow me toThêm

Dear Sir/ Madame,
If you are looking for top quality and quick turnaround then we will be delighted to start co-operation with you. Our abundant experience in the field of web design, development and programming hThêm

Dear sir you should try to use mysqlcc. If you have 2 dedidcated servers you should define access permissions betwen both of them. then you must create the script to transfer the data and then define you time table to Thêm

We are a rapidly growing 8 years old global consulting and IT services company.
Our Motto : excellence through quality
We are entering into CMM Level 5 and our development activities are process-driven.
We can proviThêm

I can have this done for you this morning ... I have experience doing this kind of script, both for backup purposes and because I do something similar myself for a script that primarily runs on one server but is accessThêm

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 :)

I can do one of two things for you: Completely comply with what you've described, sending the contents of an entire database to a different server, Or I could set up your architecture to allow the script on the other sThêm