Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

back up my sql table on the local machine

 
Tharaka Peiris
Greenhorn
Posts: 11
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
grapes are vegan food pellets. Eat this tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!