|
|
| Line 1: |
Line 1: |
| − | Database dumps are produced by script:
| + | #redirect [[Anarchopedia:Technic]] |
| − | | + | |
| − | #!/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/.
| + | |
| − | *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/.
| + | |
| − | *Database dumps for fra can be found at http://fra.anarchopedia.org/dev/db/.
| + | |
| − | *Database dumps for hrv can be found at http://hrv.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 srp can be found at http://srp.anarchopedia.org/dev/db/.
| + | |
