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