http://qs321.pair.com?node_id=20268


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.