How To Set Up Cron Job To Restart Mysql
Nov 23, 2008How 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?
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?
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...?
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 RelatedMy 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?
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 .......
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 RelatedI'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
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
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.
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.
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
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
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?
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 RelatedWhat 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] ...
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
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?
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
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.
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.
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 RelatedSince 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..
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.
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 Relatedi 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 Relatedhow 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.
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?