Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^2: Cross platform database table backup/restore

by gwhite (Friar)
on Oct 15, 2010 at 19:26 UTC ( [id://865550]=note: print w/replies, xml ) Need Help??


in reply to Re: Cross platform database table backup/restore
in thread Cross platform database table backup/restore

We are giving the client the option to merge (but not add) some data into the database

We want to take a snapshot of the table premerge, if they discover something is awry (sometimes days and several updates later) we want the premerge data. Some of our clients have 100,000+ records in each of 5-6 tables. Encoding and such isn't an issue, we just support various DB platforms, so I was hoping there was a module that let me do something like a $dbh->backup($mytable_name, $myholding_file); & a $dbh->restore($myholding_file, $mytable_name); (and yes I know if updates have been made we may need to do more, but this would be enough 75% of the time)

g_White
  • Comment on Re^2: Cross platform database table backup/restore

Replies are listed 'Best First'.
Re^3: Cross platform database table backup/restore
by gwhite (Friar) on Oct 15, 2010 at 19:31 UTC

    And the export/import to/from CSV or XML or SQL would work, just looking to see if there was a cross platform tool that did this amongst some of the cryptic DBIx module names....

    g_White

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (5)
As of 2024-04-19 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found