File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Take table backup without Select * into Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Take table backup without Select * into" Watch "Take table backup without Select * into" New topic

Take table backup without Select * into

Tushar Londhe

Joined: Jul 08, 2008
Posts: 3
Hi Guys,

I want to take backup of a table.
But I dont want to use Select * into, so is there any other query
which I can fire in order to get table backup.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46412
Depending on your database program, you ought to have a dump utility. This example is for MySQL5.0.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

I don't understand, SELECT is the only query that reads data from the database, so unless you want to make a backup out of thin air, you'll need to use the SELECT command in some fashion or another.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Take table backup without Select * into
It's not a secret anymore!