Same experieince. Webmin is cool for everything, especially the backup.pl script that it generates. Tom Klem *********** REPLY SEPARATOR *********** On 06/15/2004 at 3:13 PM Sasa Stupar wrote: >Steve Buehler pravi: > >> I am having a problem with a backup script that is written in a shell >> (/bin/sh) script to backup my mysql databases. For some reason on any >> day with an even number I get the following error: >> MySQL could not be stopped, exiting... >> It is really weird because it will run on odd number days without a >> problem. Should I put some kind of a wait in the script after it stops >> the mysqld and before it checks to make sure the pid file is still >> there? If so, does anybody know how? I am not sure that that will >> solve the problem though because it exits afterward and the mysql daemon >> is still running without having to restart it. Below is the relevant >> part of the script. >> The script is run from cron with this line >> 0 1 * * * /root/backup/backup.sh >/dev/null 2>&1 >> But since the logs do show it running, That shouldn't be the problem. >> Thanks >> Steve >> >> ######### Perform myisamchk >> #mysqladmin -p$MYSQLPWD shutdown >> /etc/rc.d/init.d/mysqld stop >> if [ -f $mysqlpid ]; then >> echo -e "MySQL could not be stopped, exiting... " >> >> /tmp/backuplog$date >> exit 1 >> else >> echo -e "Checking MYI tables for all databases " >> >> /tmp/backuplog$date >> myisamchk --silent --force --fast --update-state -O >> key_buffer=64M \ >> -O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M \ >> /var/lib/mysql/*/*.MYI >> fi >> echo -e "Checks complete, starting MySQL " >> /tmp/backuplog$date >> /etc/rc.d/init.d/mysqld restart >> sleep 20 >> if [ ! -f $mysqlpid ]; then >> echo -e "MySQL failed to start, exiting... " >> >/tmp/backuplog$date >> exit 1 >> fi >> ########## >> >> > >I have setup MySQL backup with Webmin and it is working fine and it is >doing backup on the fly. Just to consider using Webmin for the backup. > >Sasa > > >-- >redhat-list mailing list >unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe >https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
