Difference between revisions of "Update SpeedyWiki lokal secara automatis"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 24: | Line 24: | ||
chown -Rf www-data.www-data /var/www/wiki | chown -Rf www-data.www-data /var/www/wiki | ||
/etc/init.d/mysql restart | /etc/init.d/mysql restart | ||
| − | + | mysqladmin --user=root --password=123456 --force drop mediawiki | |
mysqladmin --user=root --password=123456 create mediawiki | mysqladmin --user=root --password=123456 create mediawiki | ||
mysql -u mediawiki -pmediawiki mediawiki < /var/www/wiki/maintenance/tables.sql | mysql -u mediawiki -pmediawiki mediawiki < /var/www/wiki/maintenance/tables.sql | ||
Revision as of 10:23, 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
Lakukan
chmod -Rf 777 /root/updatewiki.sh
Set cron
sudo su - crontab -e
isi
0 3 * * * /root/updatewiki.sh