Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (11)
As of 2017-10-19 20:49 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (257 votes). Check out past polls.