Backup using CMD Windows Server 2008R2?

Question

cmd/bat

There is a server with Windows Server 2008R2 + MySQL+IIS, on which you need to copy several subfolders from the C:\inetpub\ folder, but you need to stop MySQL before doing it. The backup should be done on an FTP server, subfolders from C:\inetpub\ should be archived. After copying, you need to enable MySQL.
How can this be done using PowerShell or CMD, so that it runs on schedule and checks that the MySQL service is running

Answer 1

net stop service name net
start service name into the Task
Scheduler arvive.zip>>ftp ftp -s:ftp add ftp(ftp.ru) del ftp exit

Answer 2

Backup programs can execute commands before and after the backup. In your case - stop and then start SQL. I use APBackUp - it can.