Update SpeedyWiki lokal secara automatis: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) No edit summary |
||
| 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 01: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