mysql backup script

[Ron Culler]

I found a perl script that I have been using for a while and it works
well.

http://worldcommunity.com/opensource/utilities/mysql_backup.html


On Wed, 2004-06-16 at 03:10, Tom Klem wrote:
> 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 at redhat.com?subject=unsubscribe
> >https://www.redhat.com/mailman/listinfo/redhat-list
>