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