Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2007, 02:41 PM
kontrabass kontrabass is offline
 
Join Date: Feb 2002
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MysqlHotCopy backup script

I'm looking for a backup solution that will:

- shut down forums with a custom 'backup in progress' message

- execute mysqlhotcopy to backup specified DB's to specified dir

- roll over backups to keep only x number backups on file

- reopen forums

The following is a script posted by masalaman over at vb.com. It does everything except shut down / open the boards:

Code:
#!/bin/sh
 
# List of databases to be backed up separated by space
dblist="testdb"
 
# Directory for backups
backupdir=/home/mysql/backup
 
# Number of versions to keep
numversions=4
 
# Full path for MySQL hotcopy command
hotcopycmd=/usr/bin/mysqlhotcopy
 
# MySQL Username and password
userpassword=" --user=root --password=password"
 
# Create directory if needed
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ] 
then
	echo "Invalid directory: ${backupdir}"
exit 1
fi
 
# Hotcopy begins here
echo "Hotcopying MySQL Databases..."
RC=0
for database in $dblist
do
	echo "Hotcopying $database ..."
	$hotcopycmd $userpassword $database ${backupdir}
	RC=$?
	if [ $RC -gt 0 ]
	then
		break;
	fi
 
	# Rollover the backup directories
	i=$numversions
	mv ${backupdir}/${database} ${backupdir}/${database}.0 2> /dev/null
	rm -fr ${backupdir}/${database}.$i 2> /dev/null
	while [ $i -gt 0 ]
	do
		 mv ${backupdir}/${database}.`expr $i - 1` ${backupdir}/${database}.$i 2> /dev/null
		 i=`expr $i - 1`
	done
done
 
if [ $RC -gt 0 ]
then
	echo "MySQL Hotcopy failed!"
	exit $RC 
else
	# Hotcopy is complete. List the backup versions!
	ls -l ${backupdir}
	echo "MySQL Hotcopy is complete!"
fi
exit 0
Can this be modified to shut down / open the forums? Thanks much!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:49 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03453 seconds
  • Memory Usage 2,155KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete