Difference between revisions of "Update SpeedyWiki lokal secara automatis"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | Asumsi | ||
| + | |||
| + | username root | ||
| + | password 123456 | ||
| + | database mediawiki | ||
| + | Lokasi file images.tar.gz dan wikidb.sql.gz di /usr/local/src | ||
| + | |||
| + | Buat Script misalnya | ||
| + | |||
| + | sudo su - | ||
| + | vi /root/updatewiki.sh.sh | ||
| + | |||
| + | Isi dengan | ||
| + | |||
| + | wget http://125.160.17.21/speedyorari/view.php?file=datawiki/wikidb.sql.gz -O /var/data/library/datawiki/wikidb.sql.gz | ||
| + | wget http://125.160.17.21/speedyorari/view.php?file=datawiki/images.tar.gz -O /var/data/library/datawiki/images.tar.gz | ||
| + | rm -Rf /usr/local/src/var | ||
| + | rm -Rf /usr/local/src/wikidb* | ||
| + | cp -Rf /var/data/library/datawiki/* /usr/local/src | ||
| + | cd /usr/local/src | ||
| + | tar zxvf images.tar.gz | ||
| + | gunzip wikidb.sql.gz | ||
| + | cp -Rf /usr/local/src/var/www/html/wiki/images /var/www/wiki/ | ||
| + | chown -Rf www-data.www-data /var/www/wiki | ||
| + | rm -Rf /var/lib/mysql/mediawiki | ||
| + | mysqladmin --user=root --password=123456 create mediawiki | ||
| + | mysql -u mediawiki -pmediawiki mediawiki < /var/www/wiki/maintenance/tables.sql | ||
| + | mysql -u mediawiki -pmediawiki mediawiki < /usr/local/src/wikidb.sql | ||
| + | /etc/init.d/mysql restart | ||
| + | cd /var/www/wiki/maintenance | ||
| + | php update.php | ||
| + | /etc/init.d/mysql restart | ||
| + | |||
| + | Lakukan | ||
| + | |||
| + | chmod -Rf 777 /root/updatewiki.sh | ||
| + | |||
| + | ==Set cron== | ||
| + | |||
| + | sudo su - | ||
| + | crontab -e | ||
| + | |||
| + | isi | ||
| + | |||
| + | 0 3 * * * /root/updatewiki.sh | ||
| + | |||
| + | |||
==Pranala Menarik== | ==Pranala Menarik== | ||
Revision as of 08:40, 1 January 2010
Asumsi
username root password 123456 database mediawiki Lokasi file images.tar.gz dan wikidb.sql.gz di /usr/local/src
Buat Script misalnya
sudo su - vi /root/updatewiki.sh.sh
Isi dengan
wget http://125.160.17.21/speedyorari/view.php?file=datawiki/wikidb.sql.gz -O /var/data/library/datawiki/wikidb.sql.gz wget http://125.160.17.21/speedyorari/view.php?file=datawiki/images.tar.gz -O /var/data/library/datawiki/images.tar.gz rm -Rf /usr/local/src/var rm -Rf /usr/local/src/wikidb* cp -Rf /var/data/library/datawiki/* /usr/local/src cd /usr/local/src tar zxvf images.tar.gz gunzip wikidb.sql.gz cp -Rf /usr/local/src/var/www/html/wiki/images /var/www/wiki/ chown -Rf www-data.www-data /var/www/wiki rm -Rf /var/lib/mysql/mediawiki mysqladmin --user=root --password=123456 create mediawiki mysql -u mediawiki -pmediawiki mediawiki < /var/www/wiki/maintenance/tables.sql mysql -u mediawiki -pmediawiki mediawiki < /usr/local/src/wikidb.sql /etc/init.d/mysql restart cd /var/www/wiki/maintenance php update.php /etc/init.d/mysql restart
Lakukan
chmod -Rf 777 /root/updatewiki.sh
Set cron
sudo su - crontab -e
isi
0 3 * * * /root/updatewiki.sh