Need tool for export/import of database

[johnny zee]

Basically I just need a java library for exporting the database (schema and data) to a file, and being able to import that file again. I want to use it as a backup feature.

Preferably it should export to a runnable sql script (like mysqlfront's export feature).

It wouldn't be impossible to implement by myself but I am hoping something similar already exists.

[Bear Bibeault]

"johnnyzee",

You have already been asked (in this post) to change your display name to conform to JavaRanch standards.

This is not optional. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Accounts with invalid display names are subject to closure.

bear
Forum Bartender

[Dmitry Melnik]

Does it really have to be a Java library? What don't you like about the toos which come with the DB?

[Blake Minghelli]

Originally posted by Dmitry Melnik:
Does it really have to be a Java library? What don't you like about the toos which come with the DB?

I agree, most databases have some kind of backup or replication feature. You could probably do it using Java but I think it would be horribly inefficient, unless your db is very small.

[johnny zee]

Apologies, I never noticed the post about changing the display name. After three days with no replies I never checked that thread again.

About the OT, I need programmatic control over the export/import functions. And since my program is java the functions should also be written in java.

[Paul Sturrock]

You could just do a Runtime.exec() to run the particular dump utility, couldn't you?

[Bear Bibeault]

I never noticed the post about changing the display name.

OK, now you know. Please change your display name prior to your next post.

thanks

[johnny zee]

Paul, I need direct programmatic control, and I need the source so I can adapt it to my specific needs if necessary.

Bear, incidentally I had already changed it before my last post (as you will notice).

[Bear Bibeault]

"johnny zee", please see the private message I just sent.