does anyone know about wiki backup and xml export automation?

[timeless]

pretty much what the title says, lm looking for any information on how to automate both database backup and xml exports so that l dont have to touch the wiki lm helping out on.

due to how large the db is l cant get a script to do it as it always heads to 500 errors...

 

[Bob2002]

Can't help I'm afraid, perhaps Dev Shed (or similar) would be a better bet ?:shrug:

 

[Mark.J]

I don't know what controls editors have over Wiki's so can't help, but doing automated backups of server (SQL, MySQL, MSSQL etc.) style databases is a piece of cake through cronjobs.

 

[timeless]

trouble is this xml based export is annoying the hell outta be, theres this script which l finally found that is called dumpBackup.php which one has to run like so through ssh:

php dumpBackup.php <action> <option>

but the annoying thing is l get the action but all it does is show me the whole wiki and not do any backup action...

 

[Mark.J]

Here's a web-based PHP script method for MySQL that I did for emergencies when SSH is down or Cron's aren't working:

<?php
  $host= 'localhost';
  $user= 'XXXXXX';
  $pass= 'XXXXXX';
  $db=   'XXXXXX';
  system(sprintf(
    'mysqldump --opt -h %s -u %s -p%s %s | gzip > %s/dump.sql.gz',
    $host,
    $user,
    $pass,
    $db,
    getenv('DOCUMENT_ROOT')
  ));
  echo '+DONE';
?>

 

[timeless]

neat, on another note after allot of trial and error l have got the dumpBackup.php working which is a supported addon for media wiki located here What we did was work out the commands "finally" as wiki staff were no help at all.. you just need to make sure that the AdminSettings.php is edited with you database username and password and that the dumpBackup.php is stored within the maintenance directory

then we wrote a script to automate those commands

#!/bin/sh
###########
#variables#
###########
timestamp=`date +%Y-%m-%d`
#path to maintenance directory
wikipath=/path/to/wiki/maintenance/directory/
#path to images dir
imagepath=/path/to/wiki/images/directory/
#path to save backups to
outputpath=/path/to/output/directory/
#current backup name
current=name.current
#full backup name
full=name.full
#image backup name
image=name.images
########################
#Do Not Edit Below Here#
########################
echo "creating Curent XML dump, please wait"
php -d error_reporting=E_ERROR $wikipath/dumpBackup.php --current  --quiet --output=gzip:$outputpath$current.$timestamp.xml.gz || exit $?
echo "done"
echo "creating Full XML dump, please wait"
php -d error_reporting=E_ERROR $wikipath/dumpBackup.php --full  --quiet --output=gzip:$outputpath$full.$timestamp.xml.gz || exit $?
echo "done"
#echo "creating image dump, please wait"
#cd $imagepath
#tar --create $outputpath$image.tgz || exit $?
#echo "done"
echo "sending email to user"
echo "A new XML backup of your Wiki is available to download from http://site.com/wiki_xml" | mail -s "New Wiki XML Backup Available" user@mail.com
echo "sending email to Ai"
echo "XML Wiki Backup completed successfully" | mail -s "New XML Backup Available" user@mail.com
echo "Backup Completed, any errors reported above"
#######
# END #
#######

basically this shell script needs to be run from root, added into the crontabs file, it exports the wiki xmls full and current edits and also tarballs the images directory for later download by the wiki owner (the person we host the wiki for annoyingly complies with wikia he seems to want to have backups publicly available to all weekly) in any case for the user who knows what he is doing its easy to see the variables needed to change to edit for their own use.