Anyone know if rebooting the server will stop backups in progress..

[WebHostPro]

This is a ongoing dream to be able to stop back ups in progress, I unfortunately run sometimes when it's not best and cause problems from it.

I know there is no way to stop it from the command prompt and killing each process is to tedious and would take hours.

What about rebooting?

Anyone think it will help, I don't want to reboot unless it seems feasible.

Thanks, Charles

 

[damainman]

a question i have, is if data is being written to a mysql database, and the server is rebooted.. would that mysql database become corrupted? Just curious

 

[PWSowner]

Rebooting will stop all operations in progress. I've done it once or twice for that reason.

As far as SQL, I don't know much about that, but from what I do know, I believe the way it works, a database isn't damaged if writing to it is abruptly stopped, but if something is being written and is not finished before a reboot, that data will be lost.

I'm pretty sure that's the difference between a graceful and forceful reboot.