Hi
I have 2 MYSQL servers One on a LAN and one on a dedicated server at an ISP.
I cannot run normal replication as my ISP does not allow this.
I have however written a script that will dump the data to a .sql file and ftp it to the server on the Web and import it.
Is this ok to run the way it is? I mean is it ok to import data in this fashion every 2hours on a live DB?
It all depends.
If your app does not store any user input which would be overwritten by the uploads, this might work. Keep in mind, though, that the standard mysqldump program inserts code which disables reference integrity checks (for performance reasons, I assume).
And if your database is large, the app which is fed by the database may stall for some time until all data is loaded.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.