How to backuping data by using Hibernate?..

[Leonardo Carreira]

Hi Friends...

I have a question..
Assume that, I have 2 databases (MySQL database server).. first database is used for Transactional database (for handling daily transactions).. both of them uses Hibernate..
And second database is used for backuping data (for historical data)..

And how to backuping the data in First database to Second database?..
do i have to use Distributed Transaction or not?..
And how to backuping it automatically by using Hibernate..
Assume that i want to backuping data every night at 12 o'clock pm..

Thanks in advance..

[Andrew Monkhouse]

Is there a reason you are not using the MySQL backup routines to do this for you? Or using the MySQL replication facilities to make an even better solution?

I'm guessing that neither solution is allowed by your assignment - would that be correct?

[Cameron Wallace McKenzie]

An ORM mapping tools isn't necessarily the right tool for doing backups and the sort. Using native database tools will be more efficient and more reliable.

-Cameron McKenzie

[Leonardo Carreira]

Thanks for the replies..

Would you like to give me any suggestion.. what tool do i have to use?..
What tool do you ussually use?

Thanks in advance..

[Paul Sturrock]

mysqldump is the one provided with MySQL.