Difference between revisions of "DeveloperWiki:Backups"

From ArchWiki
Jump to: navigation, search
(BBS)
Line 9: Line 9:
 
  | gzip -c > bbs-schema.sql.gz
 
  | gzip -c > bbs-schema.sql.gz
 
   
 
   
  mysqldump -uXXX -pXXX fluxbb \
+
  mysqldump -uXXX -pXXX --hex-blob fluxbb \
 
  --no-create-info \
 
  --no-create-info \
 
  --single-transaction --quick \
 
  --single-transaction --quick \

Revision as of 12:13, 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

Flyspray

Mailman

ArchWeb

Git

SVN