mysql backup script

[Tom Klem]

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