Difference between revisions of "Anarchopedia:Technic"

From Anarchopedia
Jump to: navigation, search
m (Reverted edits by 204.39.95.9 (Talk); changed back to last version by Anna)
Line 13: Line 13:
 
   print "bzip2 anarchopedia-".$date.".sql\n";
 
   print "bzip2 anarchopedia-".$date.".sql\n";
 
   print "mv anarchopedia-".$date.".sql.bz2 /srv/www/virtual/org.anarchopedia/htdocs/db/\n";
 
   print "mv anarchopedia-".$date.".sql.bz2 /srv/www/virtual/org.anarchopedia/htdocs/db/\n";
   print "chmod a+r /srv/www/virtual/org.anarchopedia/htdocs/db/anarchopedia-".$date.".sql.bz2\n";
+
   print "chmod a r /srv/www/virtual/org.anarchopedia/htdocs/db/anarchopedia-".$date.".sql.bz2\n";
  
  

Revision as of 19:30, 1 September 2007

MySQL dumps

Database dumps are produced by script:

 #!/usr/bin/perl -w
 use POSIX qw(strftime);
 $date = strftime "%Y%m%d%H%M", gmtime;
 print "mysqldump --opt -uusername -ppassword anarchopedia cur old > anarchopedia-".$date.".sql\n";
 print "bzip2 anarchopedia-".$date.".sql\n";
 print "mv anarchopedia-".$date.".sql.bz2 /srv/www/virtual/org.anarchopedia/htdocs/db/\n";
 print "chmod a r /srv/www/virtual/org.anarchopedia/htdocs/db/anarchopedia-".$date.".sql.bz2\n";


Crontab job:

 0  1    * * *   root    /srv/system/bin/ap-mysqldump.pl | sh

(MySQL dumps are generating every day at 01:00 CDT.)

  • Database dumps for meta can be found at http://meta.anarchopedia.org/dev/db/. (in moment not available)
  • Database dumps for deu can be found at http://deu.anarchopedia.org/dev/db/.
  • Database dumps for eng can be found at http://eng.anarchopedia.org/dev/db/. (in moment not available)
  • Database dumps for fra can be found at http://fra.anarchopedia.org/dev/db/.
  • Database dumps for ita can be found at http://ita.anarchopedia.org/dev/db/.
  • Database dumps for spa can be found at http://spa.anarchopedia.org/dev/db/.
  • Database dumps for dan can be found at http:
  • Database dumps for dut can be found at http:
  • Database dumps for rus can be found at http:
  • Database dumps for nsh can be found at http:
  • Database dumps for ara can be found at http:
  • Database dumps for por can be found at http:
  • Database dumps for pol can be found at http:
  • Database dumps for chi/zho can be found at http:
  • Database dumps for jpn can be found at http:
  • Database dumps for nor can be found at http:
  • Database dumps for nno can be found at http:
  • Database dumps for hrv/srp can be found at http: nsh
  • Database dumps for ind can be found at http:
  • Database dumps for swe can be found at http:
  • Database dumps for epo can be found at http:
  • (Database dumps for ell/gre can be found at http:)