I was wondering if there is a way to backup a mysql database through hibernate. What I want to be able to do is use the web application to make a call to the database to create a database backup file then upload it to my local computer [i.e. mysqldump?]. Is this possible?

Thanks in advance!


B

HI,

What we are doing is: Load any object from the db, serialize them and zip them. To restore we use the session.replicate() method.
Its not a performant solution, but we exchange data between 2 database systems (HSQLDB,MySQL) so its a mutch better way then to use sql scripts. For your case maybe you can just create a sql dump of the db, the file you can zip too.

Hope this helps, let me know.