You should close your board before backing up.
The mysqldump will create the file as you select it; it will do it immediately.
Automating the process would be possible, but I'd recommend doing it manually, then you know when to re open when the backup is done.

the backup should just take a couple of seconds/minutes.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!