Well for many situations the ideal solution is to create your own migration script/application and run it nightly. That being said, most of the GUI tools support moving data, you may wish to look at applications like SQLyog and Navicat for their offerings, as both can run scheduled data transfers.
For More Information
- Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
- The Best MySQL Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in May 2004