How can I backup a mysql database from Java? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improv开发者_如何学Goe this question? Update the question so it focuses on one problem only by editing this post.

Closed 7 years ago.

Improve this question

How can I backup a MySQL database using a Java program?

---

execute mysqldump from java code

Example:

Backup :

Runtime.getRuntime().exec("mysqldump -u USERNAME -pPASSWORD DBNAME > /path/to/location/backup.sql");

Restore:

Runtime.getRuntime().exec("mysql -u USERNAME -pPASSWORD < /path/to/location/backup.sql");

---

Runtime.getRuntime().exec("mysqldump -uroot -psome_password database_name > /whereever/dump_todays_date.sql");

---

If you are looking for a window version?

This may help:

how can i backup and restore date from mysql data base

---

See this forum, may you get help

http://www.programmingforums.org/thread19446.html