Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2020-05-25 02:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If programming languages were movie genres, Perl would be:















    Results (143 votes). Check out past polls.

    Notices?