Difference between revisions of "DeveloperWiki:Backups"

From ArchWiki
Jump to: navigation, search
(Community Repos)
(Flyspray)
Line 41: Line 41:
  
 
== Flyspray ==
 
== Flyspray ==
 +
* Server: gudrun
 +
* Backup commands:
 +
mysqldump -uflyspray -pxxx flyspray \
 +
        --no-data \
 +
        | gzip -c > bugs-schema.sql.gz
 +
 +
mysqldump -uflyspray -pxxx --hex-blob flyspray \
 +
        --no-create-info \
 +
        --single-transaction --quick \
 +
        --ignore-table=flyspray.flyspray_cache \
 +
        | gzip -c > bugs-data.sql.gz
 +
 +
tar czf bugs-htdocs.tar.gz /srv/http/vhosts/bugs.archlinux.org/
 +
 +
* Space needed: 160MB
  
 
== Mailman ==
 
== Mailman ==

Revision as of 14:07, 4 December 2010

This page provides an overview of the Arch Linux services that require backed up.

BBS

  • Server: gudrun
  • Backup commands:
mysqldump -uXXX -pXXX fluxbb \
	--no-data \
	| gzip -c > bbs-schema.sql.gz

mysqldump -uXXX -pXXX --hex-blob fluxbb \
	--no-create-info \
	--single-transaction --quick \
	--ignore-table=fluxbb.online --ignore-table=fluxbb.search_cache \
	--ignore-table=fluxbb.search_matches --ignore-table=fluxbb.search_words \
	| gzip -c > bbs-data.sql.gz

tar -czf bbs-htdocs.tar.gz /srv/http/vhosts/bbs.archlinux.org/
  • Space needed: 200MB

Wiki

  • Server: gudrun
  • Backup commands:
mysqldump -uXXX -pXXX archwiki \
	--no-data \
	| gzip -c > archwiki-schema.sql.gz

mysqldump -uXXX -pXXX --hex-blob archwiki \
	--no-create-info \
	--single-transaction --quick \
	--ignore-table=archwiki.hitcounter --ignore-table=archwiki.searchindex \
	--ignore-table=archwiki.l10n_cache --ignore-table=archwiki.objectcache \
	--ignore-table=archwiki.querycache --ignore-table=archwiki.querycachetwo \
	--ignore-table=archwiki.querycache_info --ignore-table=archwiki.transcache \
	| gzip -c > archwiki-data.sql.gz

tar -czf wiki-htdocs.tar.gz /srv/http/vhosts/wiki.archlinux.org
  • Space needed: 570MB

Flyspray

  • Server: gudrun
  • Backup commands:
mysqldump -uflyspray -pxxx flyspray \
       --no-data \
       | gzip -c > bugs-schema.sql.gz

mysqldump -uflyspray -pxxx --hex-blob flyspray \
       --no-create-info \
       --single-transaction --quick \
       --ignore-table=flyspray.flyspray_cache \
       | gzip -c > bugs-data.sql.gz

tar czf bugs-htdocs.tar.gz /srv/http/vhosts/bugs.archlinux.org/
  • Space needed: 160MB

Mailman

ArchWeb

Git

SVN

Note: should probably do a full backup monthly followed by incremental backups daily.

Core/Extra Repos

  • Server: gerolde
  • Backup commands:
svnadmin hotcopy /srv/svn-packages/ svn-packages --clean-logs
svnadmin verify --quiet svn-packages
tar -czf svn-packages.tar.gz svn-packages
rm -rf svn-packages
  • Size needed: 4GB (estimated)

Community Repos

  • Server: sigurd (could be done using rsync copy on gerolde)
  • Backup commands:
svnadmin hotcopy /srv/svn-packages/ svn-community --clean-logs
svnadmin verify --quiet svn-community 
tar -czf svn-packages.tar.gz svn-community
rm -rf svn-community
  • Size needed: 1.1GB