Dumping Seluruh Database MediaWiki: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
Onnowpurbo (talk | contribs)
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
Untuk dumping seluruh database [[MediaWiki]] seperti Situs [http://opensource.telkomspeedy.com/wiki/ SpeedyWiki]
Untuk dumping seluruh database [[MediaWiki]] seperti Situs [http://opensource.telkomspeedy.com/wiki/ SpeedyWiki]


  # /usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase -c | /bin/gzip -9 > /folder/data/datawiki/wikidb.sql.gz
==Untuk 16.04==
  # tar czf /folder/data/datawiki/images.tar.gz /var/www/html/wiki/images
 
 
/usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase --xml > file.xml
/usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase -c > /var/www/html/pustaka/datawiki/wikidb.sql
tar czf /var/www/html/pustaka/datawiki/images.tar.gz /var/www/html/wiki/images/
tar czf /var/www/html/pustaka/datawiki/wikidb.sql.tar.gz /var/www/html/pustaka/datawiki/wikidb.sql
tar czf /var/www/html/pustaka/datawiki/wikidb.xml.tar.gz /var/www/html/pustaka/datawiki/wikidb.xml
 
 
==Cara Lama==
 
  /usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase -c | /bin/gzip -9 > /folder/data/datawiki/wikidb.sql.gz
  tar czf /folder/data/datawiki/images.tar.gz /var/www/html/wiki/images




Line 26: Line 38:
* [[MediaWiki - Proteksi Spammer Menggunakan ConfirmEdit]]
* [[MediaWiki - Proteksi Spammer Menggunakan ConfirmEdit]]
* [[MediaWiki - Proteksi Spammer Menggunakan wgSpamRegex]]
* [[MediaWiki - Proteksi Spammer Menggunakan wgSpamRegex]]
* [[Script Re-Install SpeedyWiki]]
* [[Script Re-Install SpeedyWiki]] '''*PENTING*'''
* [[Script Re-Install SpeedyWiki di Ubuntu 10.04]]
* [[Script Re-Install SpeedyWiki di Ubuntu 10.04]] '''*PENTING*'''
* [[Update SpeedyWiki lokal secara automatis]]
* [[Update SpeedyWiki lokal secara automatis]]
* [[Update database SpeedyWiki lokal secara automatis tanpa update Image]]
* [[Update database SpeedyWiki lokal secara automatis tanpa update Image]]

Latest revision as of 11:53, 4 October 2016

Untuk dumping seluruh database MediaWiki seperti Situs SpeedyWiki

Untuk 16.04

/usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase --xml > file.xml
/usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase -c > /var/www/html/pustaka/datawiki/wikidb.sql
tar czf /var/www/html/pustaka/datawiki/images.tar.gz /var/www/html/wiki/images/
tar czf /var/www/html/pustaka/datawiki/wikidb.sql.tar.gz /var/www/html/pustaka/datawiki/wikidb.sql
tar czf /var/www/html/pustaka/datawiki/wikidb.xml.tar.gz /var/www/html/pustaka/datawiki/wikidb.xml


Cara Lama

/usr/bin/mysqldump -u wikiuser -pwikipasswd wikidatabase -c | /bin/gzip -9 > /folder/data/datawiki/wikidb.sql.gz
tar czf /folder/data/datawiki/images.tar.gz /var/www/html/wiki/images


Agar dapat dilakukan secara periodik

  • masukan perintah di atas dalam script
  • beri permission agar dapat di execute script tersebut (chmod +x namascript.sh)
  • edit 'crontab -e' masukan agar script di execute secara periodik


Pranala Menarik