Hi All

Kindly Suggest Me a way to take Backup of Mysql Database Through Batch File.

The Batch File i create would be called from Delphi Applications.

If any one have got Success in doing so , kindly help me out.

Thanks in Advance

Regards

Balu

http://dev.mysql.com/doc/refman/4.1/en/backup.html

Here is an example of the batch file I use:

mysqldump --opt --host=localhost --user=myUser --password=myPass --result-file=C:\Backups\myBackupFile.sql myDatabase

Once you have the batch file you can create an scheduled task with the Windows Task Manager to automatize this process

alejandro, thanks for your effort, but please do not revive a thread that has been dead for so many years

the original poster is surely not still waiting over five years for an answer, and if there's anyone else who has a question about mysql backups, we want them to start a new thread