Bash script to backup a Drupal site with an SQLite database
Script to backup via ftp a Drupal site that uses a database SQLite and to then archive it.
backup_site.sh:
#!/bin/bash
# License: GPL
#
# Author: Mentor <[email protected]>
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
#
HOST='ftp.site.com'
USER='username'
PASSWORD='password'
BACKUPDIR=$HOME'/backup/site'
WORKINGDIR='/tmp'
DBPATH='sites/default/files'
DBNAME='.ht.sqlite'
cd $WORKINGDIR
wget -m --preserve-permissions --user=$USER --password=$PASSWORD ftp://$HOST
sqlite3 $HOST/$DBPATH/$DBNAME "VACUUM;"
while [ $? -ne 0 ]; do
wget -m --preserve-permissions --user=$USER --password=$PASSWORD ftp://$HOST/$DBPATH/$DBNAME
sqlite3 $HOST/$DBPATH/$DBNAME "VACUUM;"
done
mkdir -p "$BACKUPDIR"
7z a -mhe -p$PASSWORD "$BACKUPDIR/$HOST-`date +%Y%m%dT%H%M`.7z" "$HOST"
rm -r $HOST
The script can been executed via cron in this way:
0 20 1 * * bin/backup_site.sh >> bin/cron.log 2>&1
Section:
Add new comment