Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Searching for Module to Mirror Database Table

by simonm (Vicar)
on Jan 23, 2006 at 17:28 UTC ( #524981=note: print w/ replies, xml ) Need Help??

in reply to Searching for Module to Mirror Database Table

Consider using a text-file dump to extract data from the old database in a consistent format and order, and then copy that to location B and use the standard "diff" tool to compare it with the previous file copied over on an earlier iteration.

By reading the diff output, you should be able to spot which lines have been deleted, which modified, and which ones added... From there, it should be relatively easy to generated the INSERT/DELETE/UPDATE queries.

Comment on Re: Searching for Module to Mirror Database Table

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://524981]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (2)
As of 2015-11-28 05:34 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (738 votes), past polls