Hi to every one
I have a doubt in
java regarding creating the MySQL database dump.
My problem is...
i have a huge content in the database. i need to take a backup of the database on every day as i boot my system or as i open the application.
i am right now using a MySql Database 4.1.12 version. i just need to have a database backup..
how can i get that..
i know that thru the command promt or thru the shell prompt i can create a back up thru the syntax mysqldump -uusername -ppassword databasename > filename
but how do i achieve that thru Java..
my application work on a desktop machine where mysql server and the application are installed..
i need to backup the database and if possible compress the database dump file
I hope i will get a solution for this query
Thanks in advance
==========
Divakar