By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

mysql startup script problem

P: n/a
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
dw*****@utrsmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.