Help:Database download

A good reason to use Wikicities is that a MySQL database of every Wikicity is available for download under the terms of the GFDL.

The database is available as a dump of the public SQL tables (this does not include private user data) and thus can be integrated into another SQL table (preferably one which mediawiki has already been installed in).

To access the download, go to:

http:// name of your wiki.wikicities.com/dbdumps/cur_table.sql.bz2 for the content of the "current" table (the most recent edit to every page),

or to: http:// name of your wiki.wikicities.com/dbdumps/old_table.sql.bz2 for the old table (every edit except the most recent).

A list of all downloads can be found at dbdumps.html. This list includes details of when the last database dump was made.

Backups
Backups of all Wikicities databases are saved to a file on the same hardware and copied (automatically) to a second server. Therefore, the backups exist on two different machines. Both machines are in the same colocation facility, so it's not quite "off-site".

Automatic script
This script may be used to download the backups, but it can be evolved. It will also need to be modified to add tablenames created in MediaWiki 1.5 as it is based on previous versions:
 * 1) !/bin/sh

set -e
 * 1) Exit on any error
 * 1) Exit on any error

NAME="your_wiki_name" BACKUP_NEW="new_backup" BACKUP_OLD="old_backup"
 * 1) The name of our wiki and our current/old backup directories
 * 1) The name of our wiki and our current/old backup directories

if test -d ${BACKUP_OLD} then rm -rf old_backup fi

if test -d ${BACKUP_NEW} then mv ${BACKUP_NEW} ${BACKUP_OLD} fi

mkdir ${BACKUP_NEW} cd ${BACKUP_NEW}

wget http://${NAME}.wikicities.com/dbdumps/cur_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/old_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/brokenlinks_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/categorylinks_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/imagelinks_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/image_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/links_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/oldimage_table.sql.bz2 wget http://${NAME}.wikicities.com/dbdumps/site_stats_table.sql.bz2

du -sh cd .. du -sh