How can I backup a mysql database from Java?
17,096
Solution 1
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");
Solution 2
Runtime.getRuntime().exec("mysqldump -uroot -psome_password database_name > /whereever/dump_todays_date.sql");
Solution 3
If you are looking for a window version?
This may help:
how can i backup and restore date from mysql data base
Author by
ultimatedeep
Updated on June 13, 2022Comments
-
ultimatedeep almost 2 years
How can I backup a MySQL database using a Java program?