Contents are Direct Alliance Corporation CONFIDENTIAL
-
Duane,
Does mysql actually start back up? Or just get hung on step(4)?
I know I have had problems running scripts over ssh because the sudo
environment user wasn't being executed as root. (where a cron_tab was
actually executing the script). Maybe make sure the env is trying to start
the script as the correct user.
-----Original Message-----
From: Duane Winner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 11:27 AM
To: [EMAIL PROTECTED]
Subject: mysql startup script problem
Hello all -
I'm having a small problem with the mysql startup script that ships with
MySQL-3.23.56-1.
I'm running on RedHat Linux.
It works fine, but I have a backup server that runs a script that passes
these commands remotely through ssh:
(1) ssh dbsys-dc "sudo /etc/init.d/mysql stop"
(2) ssh dbsys-dc "sudo tar
czpf - /var" > dbsys-dc.var.$(date -I).tgz
(3) ssh dbsys-dc "sudo tar czpf
- /db" > dbsys-dc.db.$(date -I).tgz
(4) ssh dbsys-dc "sudo
/etc/init.d/mysql start"
Essentially, what I'm doing is stopping the mysql server, then backing up
the directories, the starting the server again.
The problem is that I have additional commands in my backup script
following line 4 above (backup additional filesystems and server, then
write all the tarballs to tape), but the mysql start script does not exit
properly after starting the mysql server, and I come in the next morning
and find that my backup script is stuck on line 4 above, so the rest of my
filesystems and servers never get backed up, nor get written to tape.
If I do a "ps aux" and find the PID for that task and kill it, then the
rest of my script will proceed.
"mysql stop" seems to exit fine -- it's just "mysql start" that seems to
keep the shell locked.
Does anybody know how to fix this or a workaround?
Thanks so much.
Duane Winner
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
This message is for the designated recipient(s) only and contains Direct
Alliance Corporation privileged and confidential information.
If you have received it in error, please notify the sender immediately and
delete the original.
Any other use of this email is prohibited.
