Difference between revisions of "Anarchopedia:Technic"
From Anarchopedia
(UQWuJtTzQJ) |
m (Reverted edits by 210.131.4.182 (Talk); changed back to last version by Rev 22) |
||
| Line 1: | Line 1: | ||
| − | + | *[[Anarchopedia:en:administration|administration]] | |
| + | *[[Anarchopedia:Bugs]] | ||
| + | *[[Anarchopedia:Tech-Report]] | ||
| + | |||
| + | ==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:) | ||
Revision as of 20:34, 20 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:)
