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: cd. #chose an EMPTY directory (it can contain the script back.sh only) rm -rf ./old_backup mv ./new_backup ./old_backup mkdir new_backup cd ./new_backup/ 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 ./* #will print the size of each file of the current backup cd .. du -sh ./* #will print the size of the current and old backup
 * 1) bash script (linux/unix only, or under cygwin and/or mingw for windows users):