vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Looking for a script to Dump SQL and web files to server (https://vborg.vbsupport.ru/showthread.php?t=303702)

XrayHead 10-22-2013 10:24 AM
Looking for a script to Dump SQL and web files to server
 
Hi All

I've been trying to set-up a CRON on my PLESK server to dump the database and httpdocs once a day, keep 5 copies and delete anything older than 5 days old. Anyway I cant seem to get it to work and I was wondering what solutions everyone else use's to do the same thing?

I was using a plugin back when I was running vBulletin v3 but would much rather do this via CRON on the server to bypass any issues if the domain is down and so on..

Xray

nhawk 10-25-2013 10:25 PM
Log in to your server as root via SSH.

Create a file called backup.sh in your root directory. (this is where you should be when you log in as root via SSH. If you aren't there type cd /root)

Put this code in the backup.sh file..

Code:
#!/bin/sh
lastbackup=$(cat backup.txt)
thisbackup=`expr $lastbackup + 1`
if [ $thisbackup -eq 5 ]
then
  echo 0 > backup.txt
else
  echo $thisbackup > backup.txt
fi

GZIP="$(which gzip)"

# Database username and password
DBUSER=yourdatabaseusername
DBPASS='yourdatabasepassword'

# Name of the tar file to create
FILE=master_backup_$thisbackup.tar.gz

# Name of the database dump file to create
DBFILE=db_backup.sql

# Dump the contents of all databases to the database dump file
mysqldump --opt -u $DBUSER -p$DBPASS --all-databases > $DBFILE

# Create the tar file adding in the contents of 'httpdocs'
# and the database dump file
# Unless you want a huge list of files, redirect
# output to /dev/null
tar -zcvf $FILE $DBFILE /var/www/vhosts/yourwebsite.com/httpdocs > /dev/null

# Remove the db sql file from the server.
rm $DBFILE
Change the permissions for backup.sh so it's executable.

Create a cron task using crontab -e

Put this in the task..

Code:
30 23 * * * /root/backup.sh > /dev/null 2>&1
Now every day at 11:30pm a new backup will take place. The files will be named...
master_backup_1.tar.gz
master_backup_2.tar.gz
master_backup_3.tar.gz
master_backup_4.tar.gz
master_backup_5.tar.gz

As time progresses, the oldest file will be overwritten with a new backup. You need to check the file dates for the newest backup.

In other words, after master_backup_5.tar.gz takes place, the count starts over and master_backup_1.tar.gz will be replaced by the new backup file.

With all that said, it makes absolutely no sense to keep a backup of your site on the same server the site is on. If the server should fail, you won't have any backups at all. Backups should be transferred to some other location for safe keeping.

XrayHead 10-26-2013 11:37 AM
Thank you so much for your help! I have been trying to get a backup solution up and running ever since I moved servers and upgraded from vB3 to vB4. I will see if I can set this up latter.

For an off site solution could you recommend anything?

Lee


All times are GMT. The time now is 06:23 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01014 seconds
  • Memory Usage 1,715KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete