Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Dumping a Database via DBI

by plaid (Chaplain)
on Jun 29, 2000 at 01:33 UTC ( #20268=note: print w/replies, xml ) Need Help??

in reply to Dumping a Database via DBI

I know you said you don't want any command-line solutions, but have you looked at mysqldump? It comes along with mysql, and lets you do things like 'mysqldump <database> <table> > outputfile'. The output of mysqldump is a set of sql statements which will recreate all tables in the database, and all things contained in the tables.. for a more in-depth description, check out mysqldump --help. I believe that most databases come with a dumper utility like this, and the dumps work well between different SQL databases. You can then recreate the contents of the database by running 'mysql <database> < outputfile'. I hope this fits what you want.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (1)
As of 2022-01-20 04:18 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (56 votes). Check out past polls.