mySQL won't shut down for backup

S

Swift-AU

Verified User
Joined
Dec 31, 2003
Messages
67
After upgrading to mySQL 4.1.10a on my FreeBSD 4.9 system, the DirectAdmin full system backup quits with the error message:

"Performing MySQL backup
Stage 1 MySQL backup:MySQL could not be shutdown, aborting..."

mySQL shuts down and restarts sucessfully if I do it via the DA Service Monitor or from the command line.

Any ideas?

Cheers...
Swift
 
Maybe sysbak isn't issuing the correct command to shut MySQL down or isn't waiting long enough for all processes to be cleared.
 
Thanks for the reply.

It turns out, as you suggested, that sysbk wasn't waiting long enough for mySQL to shutdown. I changed it from 4 to 10 seconds, and now all is well.

Cheers...
Swift
 
Most likely in the sysbak conf file. Just a guess. If not, then the command in the actual sysbak script that shuts mysql down.
 
I found it; it's in:

/usr/local/sysbk/mod/mysql.bk

in line 10; change the number after sleep to the number of seconds you want to wait.

Jeff
 
You must log in or register to reply here.
Back
Top