User:Flominator/Backup MW

#!/bin/bash
FNAME=`date +%y-%m-%d`
mysqldump --database DATABASE_NAME -u USERNAME -pPASSWORD --add-drop-table -B > ${FNAME}.sql
zip -r ./backup/${FNAME}.zip images/ ${FNAME}.sql LocalSettings.php extensions/ -x  backup/
rm ${FNAME}.sql

#Count files in directory (hidden files (filename starts with a dot) are ignored) 
file_count=`ls | wc -l` 
 
#Do until there are more than or equal 6 files present
while [ $file_count -ge 6 ]
do
        #you can save deleted filenames in variable (e.g. for deleting files also in backup directory)
        #not recommended for filenames with space(s)
        del_files="${del_files} `ls | head -n 1`"
        #Delete alphabetically oldest file (ls sort by name is default)
        rm `ls | head -n 1` 
        #Count files again
        file_count=`ls | wc -l`
done

 <?php
 exec("./backup.sh");
 $filename = strftime("%y-%m-%d");
 header("Content-Type: application/octet-stream");
 header("Content-Disposition: attachment; filename=WIKINAME_".$filename.'.zip');
 echo readfile("backup/".$filename.".zip");
 ?>

@echo off
SET drive=C:
SET exefolder=%drive%\xampp
SET folder=%exefolder%\htdocs\wikifolder
SET temp=%folder%\temp
SET username=root
SET password=proot
SET database=wikidb
 
MD %temp%
ECHO Copy %1 to %temp%
COPY %1  %temp%
 
%drive%
CD %exefolder%
xampp_stop
xampp_start
 
ECHO Changing current directory to %folder%
CD %folder%
 
ECHO Deleting old folder images
RD /s /q images
 
ECHO Deleting old folder extensions
RD /s /q extensions
 
ECHO Unzipping file by using [http://www.info-zip.org/UnZip.html unzip]
CD temp
FOR /F "delims=!" %%n in ('dir *.zip /b') DO (unzip -o  %%n -d "%folder%"
 del %%n
 )
 
CD ..
ECHO Deleting old database
%exefolder%\mysql\bin\mysql -u %username% -p%password% -e "drop database %database%;" 
 
ECHO Creating database
%exefolder%\mysql\bin\mysql -u %username% -p%password% -e "create database %database%;" 
 
FOR /F "delims=!" %%m in ('dir *.sql /b') DO (echo Importing from %%m
 %exefolder%\mysql\bin\mysql -u %username% -p%password% -D %database% < %%m
 del %%m
)
PAUSE

 [[$wgHashedUploadDirectory]] = true;