tranferring databases to another server

[sknyppy]

I need to write a script batch file that will transfer the contents of a mySQL database from one server to another every 15 minutes. I assume I can set up a windows task to accomplish the script execution part.

Is anyone know the syntax of the mySQL command line needed to copy the database to a text file then ftp the text file to another server which would restore the new database???

Any help would be appreciated....

Thanks,
Dave

 

[KarveR]

MySQL supports replication, would that be an option?
***************************************
Party on, dudes!

 

[sonnysavage]

Here's a link to the MySQL manual for replication:

http://www.mysql.com/doc/R/e/Replication.html