Mysql back up on request using hibernate

Question

Is it possible to take the backup of mysql database using hibernate ? Share your ideas. I am using hibernate mapping xml for pojo mapping with table.

score 1 · Answer 1 · edited May 23 '17 at 10:25

1

AFAIK, Hibernate not providing features for backup or restore.

How ever you should consider to do it from command line, which you can execute through java.

edited May 23 '17 at 10:25

Community

answered Oct 09 '13 at 11:11

Suresh Atta

score 0 · Answer 2 · answered Oct 09 '13 at 11:26

0

Hibernate does not provide database backup functionality and here is why,

Hibernate is an OR mapping tool and primarily aimed as objectifying the database so that the code developers don't have to bother about databases interaction intricacies and never have to work with database directly.
Database backups are taken by DB administrators (and not developers) who very closely work with the databases and are familiar with tools and terminologies. Hence tools like hibernate do not have any role here to play.

answered Oct 09 '13 at 11:26

Santosh

your point is acceptable. but if we develop application like console for DB admin to simplify their work and if we are using hibernate in that application, we may need this functionality rite. It is just my thought. Any how thanks for your information – Md Ismail Oct 09 '13 at 11:35
In that case to, using Hibernate may not be a wise idea. For an application like DB admin console, the internal mysql command would be faster and efficient. – Santosh Oct 09 '13 at 11:41

score 0 · Answer 3 · answered Oct 09 '13 at 11:40

0

Here follows some solutions

You can create hibernate with ant for restore/backup database This Link provide more information about that
Here follows another solution for backup/restore tables programatically using hibernate

answered Oct 09 '13 at 11:40

Anish Antony

But it is for single table. i need to take full DB dump. – Md Ismail Oct 09 '13 at 11:48
Thanks. But it is a one of the work around solution. not a direct solution. – Md Ismail Oct 09 '13 at 13:02

3 Answers3