I currently have an application (php/mysql) running on 3 different web hosts. At each host, I have the typical cpanel/phpMyAdmin type of access. I currently have clients spread across all 3 servers, but would like to move all clients to the newest server.
Due to the nature of the application and data (sales transactions), I currently have to synchronize real-time with each client, have them cease transactions, then I export their data via phpMyAdmin, import it the same way on the new server, and then have them resume transactions against the new server, by using a new URL. However, this is impractical due to the number of clients, time zone differences, etc.
So I am looking for ideas on how to export sql data from one webhost, and import it to another, in some automated way that can be initiated by the client. I have a lot of tools at my disposal, so the technological limits are few. Any ideas?