Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
1  
if you have cpanel/phpmyadmin access do you have root (shell) access? i.e. are you running on a vps (or better) or a hosted server? –  helloandre Jun 23 '11 at 17:34
    
The target is a VPS, the two sources are simple hosted accounts, with no significant access other than through cpanel. –  dts_sl Jun 24 '11 at 6:10
add comment

migrated from stackoverflow.com Jun 23 '11 at 17:44

This question came from our site for professional and enthusiast programmers.

2 Answers

Have you considered Replication?

Good article on the subject: http://www.howtoforge.com/mysql_database_replication

share|improve this answer
    
I don't have that level of access, as these are two hosted accounts, being transferred to a VPS. –  dts_sl Jun 24 '11 at 6:12
add comment

cpanel should have a whole account transfer that will automatically copy absolutely everything from one server to another. Maybe that is what you need?

share|improve this answer
    
Clients are continually generating more sales data, updating running totals, etc. Data copied to the new server is immediately out of date unless the client ceases generating data, does the copy, and then starts pointing their transactions at the new server. The process has to be initiated by my clients using my web app, since the idea is to get me out of the loop, and let them decide when to cease operations, copy the data, and resume against the new server. Hope that makes sense! –  dts_sl Jun 24 '11 at 6:19
    
they could also just start pointing their transactions to the new server without any interruption of service. It seems like copying the old data could be done asyncronously of that. –  helloandre Jun 24 '11 at 14:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.