How To Set Up Cron Job To Restart Mysql

Nov 23, 2008

How to set up cron job automatic restart mysqld at specified time. My case, mysqld will auto restart every 23 hours running.

How to set up this cron job?

View 12 Replies


ADVERTISEMENT

Cron Job Not Working, Restart Services

Jan 1, 2008

I'm having a bit of trouble with one cron job that doesn't seem to work.

I have others scripts that run hourly fine. However this one does not.

The script:

restart_monitoring.sh

Code:
#!/bin/bash
service iptables stop
service iptables start
/root/bandwidth_rules.sh
/root/portforward_config.sh
exit
The two scripts at the end just load a lot of iptables rules back in.

The cron job should run hourly (59th minute)

The cron job entry

Code:
59 * * * * /root/restart_monitoring.sh
I have restart crond to enable the new job, still doesn't run.

The job is to restart iptables, thus flushing all rules that I have running, then reloading them. I have figured out the problem to be with the "service iptables stop/start" command, it doesn't seem to like doing this...?

View 2 Replies View Related

Auto Restart Apache On Cron

May 22, 2007

ive got a fairly beefy server but at the moment its hosting alot of resource intensive sites (unfortunatly i dont currently have a choice on where to run them all) and apache is crashing to the point its taking upto 2 mins to load pages within about 24hours but once restarted is fine again. so im wondering if anyone can suggest a way to automaticly restart apache via a cron job every 24hours or so?

View 6 Replies View Related

How To Add Cron To Restart Apache Server Every Three Hours

May 5, 2008

My host is experiencing "issues" with my WordPress. It keeps going above their upper limit of open MySQL connections. So, while I am diagnosing it, I need to restart the server every few hours to avoid it going down.

How do I write a cron to restart Apache every 3 hours?

View 5 Replies View Related

Howto: Automatically Verify Cron / Crond Is Running And Restart If Not

May 30, 2005

This one's pretty simple really, but given the fact that I'm constantly running into crond stops with CPanel servers (no clue why, or where, but it's happening), I'll post this here. If it helps someone, then great, if not, hey, no worries.

Firstly, login as root to your server through ssh, however you usually do .

Next, the script (we'll call it /bin/croncheck.sh). Use whatever editor you choose to create the file.

#!/bin/bash .......

View 14 Replies View Related

Mysql.sock Gone And Mysql Restart Doesn't Create It

Jun 16, 2008

For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.

View 5 Replies View Related

How To Restart Mysql

Mar 16, 2007

I'm on FreeBSD 6.2 dedicated server with root access control-panel Directadmin

Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.

try to do restart and after this mysql service is down too.

all my attempts to do restart aren't successful.

1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped

try to do mysql restart with this command

/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file

try to connect to mysql and get such output

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in

View 9 Replies View Related

How To Restart Mysql

Mar 16, 2007

I'm on FreeBSD 6.2 dedicated server with root access
control-panel Directadmin

Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.

try to do restart and after this mysql service is down too.

all my attempts to do restart aren't successful.

1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped

try to do mysql restart with this command

/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file

try to connect to mysql and get such output

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in

View 1 Replies View Related

Mysql Auto Restart

Dec 5, 2008

Is anyone experiencing that cpanel automatically restarts mysql at 2AM?

I'm curious is that new feature or something has gone wrong?

This has started after cpanel upgrade mysql to 5.0.67 version.

I'm not so good with cpanel so please can somebody tell me where cpanel holds its crons?

I cannot find nothing in /etc/cron.* or in cron -l, and I want to turn this option off.

View 2 Replies View Related

Failed To Restart Mysql Service

Apr 12, 2009

My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed

And when restart (by WHM )

Restarting MySQL Server

whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.

mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275

mysql has failed, please contact the sysadmin (result was "mysql has failed").

My VPS in unmanaged, i can't access mysql.

View 4 Replies View Related

Mysql Error Message And Restart

Jun 1, 2008

One of our servers mysql daemon is restarting most of the time and got the error message in the message file. Did anyone see similar error message?

Jun 1 05:46:44 kernel: audit(1212317204.342:6991): avc: denied { read } for pid=17286 comm="mysqld" name="/" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.343:6992): avc: denied { getattr } for pid=17286 comm="mysqld" path="/tmp" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.346:6993): avc: denied { read } for pid=17286 comm="mysqld" name="time_zone_leap_second.frm" dev=hda2 in

View 1 Replies View Related

Cannot Restart MySQL, HTTPD And Server

Nov 22, 2007

I am not being able to restart the server, or MySQL or httpd via SSH.

PHP Code:

root@server [~]# /etc/init.d/httpd fullstatusLooking up localhostMaking HTTP connection to localhostAlert!: Unable to connect to remote host.lynx: Can't access startfile http://localhost/server-statusroot@server [~]# 

PHP Code:

root@server [~]# /etc/init.d/mysql reload/etc/init.d/mysql: line 244: kill: (3375) - No such processtouch: cannot touch `/var/lib/mysql/server.lubnan.us.pid': Read-only file system 

View 14 Replies View Related

MySQL Restart On CentOS - Chown

Sep 18, 2007

I have a lot of tables, being that I host multi forums. One thing I noticed when doing a mysql start up or restart is that it takes at least 15 minutes to do it. The server isn't bad, it's a Pentium D with 3GB of RAM and it runs perfectly fine. What I noticed is that after I do an SQL restart, I checked "top." The command that was running is "chown" and it sat at the top of the list, and kept going. Until finally mysql started and it stopped.

I imagine that all of the files in the data folder are being CHOWNed... and that's why it takes forever. If this is the case, how can I stop this, if at all? I don't see why they need to be CHOWNed?

View 4 Replies View Related

Automatically Restart Mysql After High Server Load

Jan 29, 2009

Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.

View 1 Replies View Related

Plesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service

Jun 5, 2014

What could I fix by trying to start mysql server, recieve following errors:

plesk interface:

Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start

from the console:

Code:
sudo service mysql start
start: Job failed to start

Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:

[Code] ...

View 4 Replies View Related

Backup MySQL Databases By Cron

Apr 1, 2007

how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working.

Change the commented variables in the following file and save it as backup.sh:

Code:
#!/bin/sh

# This script will backup one or more mySQL databases
# and then optionally email them and/or FTP them

# This script will create a different backup file for each database by day of the week
# i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1)
# This is a trick so that you never have more than 7 days worth of backups on your FTP server.
# as the weeks rotate, the files from the same day of the prev week are overwritten.
#/bin/sh /home/user/directory/scriptname.sh > /dev/null
############################################################
#===> site-specific variables - customize for your site

# List all of the MySQL databases that you want to backup in here,
# each seperated by a space
# If not run by root, only one db per script instance
databases="mydbname"

# Directory where you want the backup files to be placed
backupdir=/home/mydomain/backups

# MySQL dump command, use the full path name here
mysqldumpcmd=/usr/bin/mysqldump

# MySQL Username and password
userpassword=" --user=myuser --password=mypasswd"

# MySQL dump options
dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

# Unix Commands
gzip=/bin/gzip
uuencode=/usr/bin/uuencode
mail=/bin/mail

# Send Backup? Would you like the backup emailed to you?
# Set to "y" if you do
sendbackup="n"
subject="mySQL Backup"
mailto="me@mydomain.com"

#===> site-specific variables for FTP
ftpbackup="y"
ftpserver="myftpserver.com"
ftpuser="myftpuser"
ftppasswd="myftppasswd"
# If you are keeping the backups in a subdir to your FTP root
ftpdir="forums"

#===> END site-specific variables - customize for your site
############################################################

# Get the Day of the Week (0-6)
# This allows to save one backup for each day of the week
# Just alter the date command if you want to use a timestamp
DOW=`date +%w`

# Create our backup directory if not already there
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ]
then
echo "Not a directory: ${backupdir}"
exit 1
fi

# Dump all of our databases
echo "Dumping MySQL Databases"
for database in $databases
do
$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql
done

# Compress all of our backup files
echo "Compressing Dump Files"
for database in $databases
do
rm -f ${backupdir}/${DOW}-${database}.sql.gz
$gzip ${backupdir}/${DOW}-${database}.sql
done

# Send the backups via email
if [ $sendbackup = "y" ]
then
for database in $databases
do
$uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu
$mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu
done
fi

# FTP it to the off-site server
echo "FTP file to $ftpserver FTP server"
if [ $ftpbackup = "y" ]
then
for database in $databases
do
echo "==> ${backupdir}/${DOW}-${database}.sql.gz"
ftp -n $ftpserver <<EOF
user $ftpuser $ftppasswd
bin
prompt
cd $ftpdir
lcd ${backupdir}
put ${DOW}-${database}.sql.gz
quit
EOF
done
fi

# And we're done
ls -l ${backupdir}
echo "Dump Complete!"
exit
Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone .

You should chmod the file to 777:

Code:
chmod 777 backup.sh
If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory:

Code:
dos2unix backup.sh
If you don't have dos2unix installed, you can install it using yum if you have that:

Code:
yum install dos2unix
If you don't have yum, get it here.

You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command:

Code:
./backup.sh
Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is:

Code:
/path/to/file/backup.sh

View 2 Replies View Related

Simplest Way To Auto Cron A Mysql Database

Oct 2, 2009

I use a php script usually but that does not work for large files.

I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?

View 14 Replies View Related

Is It Possible To Create A Cron To Backup Mysql Data Daily

May 15, 2009

Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily

mysqldump -u usernam -p password dataname > file.sql

View 11 Replies View Related

Host Recommendation (Req: PHP5, MySQL, CRON, Mass-Email)

Sep 1, 2009

any hosts that can provide the following:

PHP5.3 +
MySQL
CRON (to run daily/weekly scripts at a certain time)
Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly.

In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.

View 3 Replies View Related

NFS Restart

Jul 3, 2007

I have directory shared by NFS on server1 this directory mounted at startup on server2.
problem happened when twice servers restarted and server2 started before server1. directory not mounted I must mount it manually.

View 4 Replies View Related

Restart

Jul 19, 2007

One of my server's http daemon is restarting more often and it doesn't have any control panel. How can I checked the load or memory usage history?

View 3 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

BIND Will Not Restart In WHM Or Via SSH

Aug 31, 2006

I get the following message via SSH when i try named restart

named: symbol lookup error: named: undefined symbol: dns_resolver_setudpsize

All my sites are currently down but the server is up and bind wont restart either in WHM or SSH

i am using WHM 10.6.0 cPanel 10.8.0-R8
CentOS 4.3 i686 - WHM X v3.1.0
Linux ***.server.com 2.6.9-11.EL #1 Wed Jun 8 16:59:52 CDT 2005 i686 i686 i386 GNU/Linux

I spoke to live support at nexpoint but they told me to email their dedicated server support but I havent had a reply in the last few hours.

View 5 Replies View Related

Restart Apache

Apr 23, 2008

I have 8 apache servers that is sharing one httpd.conf file... When changes made in the httpd.conf, you have you restart httpd... How can I restart all 8 servers at the same time instead of logging into each server and do it manually?

View 2 Replies View Related

Ftp Wont Restart Ftp Is Down

Oct 13, 2009

i am having an issue with my vps recently my ftp is down and i cant restart my ftp not sure how i can get this fix.

View 8 Replies View Related

How To Restart Lighthttpd

May 28, 2009

how to restart lighthttpd?

I was asked to restart lighthttpd at my friend host, he has 6 sites running, and of the site is down, host has asked him to restart the server, as he is away, he wanted me to restart, but I have no clue how to restart lighthttpd,

It will be really helpful if u can guide me for : if possible for the domain alone, else for the entire server

current options available :
lxadmin - hypervm
ssh connection

let me know the steps and code if any.

View 4 Replies View Related

Can't Restart Apache

Jul 17, 2009

We are unable to restart apache on our server, as a result no sites are accessible in the browser. Our host states we need to clear out the following files:

[root@server1 logs]# ls -lAh|grep -v ' 0 '
total 1.9G
-rw-r--r-- 1 root root 92M Jul 17 07:55 access_log
-rw-r----- 1 root root 463K Dec 9 2007 audit_log
-rw-r--r-- 1 root root 1.2G Jul 17 07:57 error_log
-rw-r--r-- 1 root root 6 Jul 17 07:42 httpd.pid
-rw-r--r-- 1 root root 92K Feb 18 2008 ssl_engine_log
-rw-r--r-- 1 root root 535M Jul 17 07:46 suexec_log
-rw-r--r-- 1 root root 10 Jul 17 03:21 suexec_log.offset
-rw------- 1 root nobody 5.6M Dec 10 2007 suphp_log

Is it ok to simply delete these files? If so, will they recreate
themselves?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved