aspose file tools*
The moose likes JDBC and the fly likes back up my sql table on the local machine Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "back up my sql table on the local machine" Watch "back up my sql table on the local machine" New topic
Author

back up my sql table on the local machine

Tharaka Peiris
Greenhorn

Joined: Jan 05, 2011
Posts: 11

I have a mysql server in another machine and i want to back up a table in a database to my local machine using java.
I have used select * into outfile command but problem is the file is saved in the server machine.

Can anyone help me to do this function which is very urgent....

Thank you.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

can you connect from the local machine using mysql-dump? that is preferred.
Otherwise you can have a quick look at dbTamer in my signature to read from the db using a JDBC connection and write the schema and data locally.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: back up my sql table on the local machine