Difference between revisions of "Update SpeedyWiki lokal secara automatis"

From OnnoWiki
Jump to navigation Jump to search
Line 33: Line 33:
 
  /etc/init.d/mysql restart
 
  /etc/init.d/mysql restart
  
Lakukan
+
Ijinkan untuk di jalankan
  
 
  chmod -Rf 777 /root/updatewiki.sh
 
  chmod -Rf 777 /root/updatewiki.sh

Revision as of 10:32, 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
/etc/init.d/mysql restart
mysqladmin --user=root --password=123456 --force drop 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

Ijinkan untuk di jalankan

chmod -Rf 777 /root/updatewiki.sh

Set cron

sudo su -
crontab -e

isi

0 3 * * * /root/updatewiki.sh


Pranala Menarik