• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Rob Spoor
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Carey Brown
Bartenders:

How to backuping data by using Hibernate?..

 
Ranch Hand
Posts: 494
Eclipse IDE Postgres Database Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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..
 
author and jackaroo
Posts: 12199
280
Mac IntelliJ IDE Firefox Browser Oracle C++ Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
author and cow tipper
Posts: 5006
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 Postgres Database Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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..
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
mysqldump is the one provided with MySQL.
reply
    Bookmark Topic Watch Topic
  • New Topic