How to take backup automatically after certain number of records in a table

[sandhu236]

Hi all,
Can anyone please help me..to take backup automatically from the frontend application (Java swing) after certain number of records

REgards,
SAndhya

[r035198x]

Hi all,
Can anyone please help me..to take backup automatically from the frontend application (Java swing) after certain number of records

REgards,
SAndhya

After the code for inserting a record is executed then call a method which checks the number of records and does the backup if the required number of records have been reached.

[sandhu236]

thanx ...
that's fine that I place amethod to check for the recordcount but ...what is the procedure for taking the backup.
I can see only the command like this...
mysqldump -u sadmin -p pass21 Customers > custback.sql
How can I execute the command in the method.???


Regards,
sandhya

[r035198x]

thanx ...
that's fine that I place amethod to check for the recordcount but ...what is the procedure for taking the backup.
I can see only the command like this...
mysqldump -u sadmin -p pass21 Customers > custback.sql
How can I execute the command in the method.???


Regards,
sandhya

You can run that command from Java using the Runtime class