Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to backuping data by using Hibernate?..

 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author and jackaroo
Marshal Commander
Pie
Posts: 12014
220
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
mysqldump is the one provided with MySQL.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic