LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 08-17-2005, 06:57 AM   #1
Fuwex
LQ Newbie
 
Registered: Sep 2004
Posts: 9

Rep: Reputation: 0
MySQL restart script?


Hi all. I'm very inexperienced with Linux, I just know some basics... Well, I'm hosting a The Specialists game server (A Half-Life mod), but one of the plugins I'm running sometimes freezes the server, shutting down MySQL. So, what I need is a script that does something like 'mysqladmin ping' once a minute, if it can't ping the MySQL, it will attempt to start it. I have very very little experience with scripting, so I'm not sure how to go forward. I'd like to solve this problem fast, as we have to manually restart the MySQL every time it crashes, and when we're not able to do that, the server stays off for longer periods.

I hope anyone is able to help with this issue.
 
Old 08-17-2005, 01:24 PM   #2
nixcraft
Member
 
Registered: Nov 2004
Location: BIOS
Distribution: RHEL3.0, FreeBSD 5.x, Debian 3.x, Soaris x86 v10
Posts: 379

Rep: Reputation: 30
You can use script monitor_mysql script: http://bash.cyberciti.biz/monitoring...ysql.bash.html

Hope this helps
 
Old 08-17-2005, 02:23 PM   #3
Fuwex
LQ Newbie
 
Registered: Sep 2004
Posts: 9

Original Poster
Rep: Reputation: 0
Thanks, seems to be just what I need. I'll try it out.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
/etc/init.d/mysql restart problem meenalborkar Debian 3 11-11-2005 07:40 AM
Mysql crashes after restart ... :( sys7em Slackware 1 11-24-2004 03:33 PM
run script when restart ust Linux - Software 4 08-25-2004 03:13 PM
Restart script blablaman Linux - Newbie 1 08-20-2004 06:09 AM
Restarting mysql database on restart psycho2000 Linux - Newbie 3 06-01-2003 08:41 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 06:57 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration