automatic SQL export

Hello Friends,

I need to establish automated process for Exporting SQL database in other folder to take a backup every weekend.

Is there way to setup this process.

Any help would be greatly appreciated.

Thanks

HeidiSQL is not automatable in that way. But mysqldump is, as it's a pure command line client.