Replikasi Database dan Image MediaWiki: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Newer edit →
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
New page: Ambil Image dan isi database [http://opensource.telkomspeedy.com/wiki SpeedyWiki] dari http://opensource.telkomspeedy.com/speedyorari/ di folder datawiki Copykan ke sebuah folder, misalny...
 
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Line 7: Line 7:
  # cp wikidb.sql.gz /usr/local/src/
  # cp wikidb.sql.gz /usr/local/src/


Bukan dan extract seluruh data
 
Buka dan extract seluruh data


  # cd /usr/local/src
  # cd /usr/local/src
  # tar zxvf images.tar.gz
  # tar zxvf images.tar.gz
  # gunzip wikidb.sql.gz
  # gunzip wikidb.sql.gz


Copy Image ke folder image di MediaWiki
Copy Image ke folder image di MediaWiki
Line 17: Line 19:
  # cd /usr/local/src
  # cd /usr/local/src
  # cp -Rf /usr/local/src/var/www/html/wiki/images /var/www/wiki/
  # cp -Rf /usr/local/src/var/www/html/wiki/images /var/www/wiki/


Lihat konfigurasi MediaWiki, dari file
Lihat konfigurasi MediaWiki, dari file
Line 30: Line 34:




Beri akses wikiuser ke tabel archive


Beri akses wikiuser ke tabel archive dan tabel wikidb


  # mysql -u root -p
  # mysql -u root -p
  Enter password:  
  Enter password:  
  Welcome to the MySQL monitor.  Commands end with ; or \g.
   
Your MySQL connection id is 20
Server version: 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
  mysql> grant ALL on wikidb.* to wikiuser@localhost;
  mysql> grant ALL on wikidb.* to wikiuser@localhost;
  Query OK, 0 rows affected (0.21 sec)
  mysql> grant ALL on archive.* to wikiuser@localhost;
mysql> quit


mysql> grant ALL on archive.* to wikiuser@localhost;
Query OK, 0 rows affected (0.09 sec)


mysql> quit


Masukan isi database dari SpeedyWiki ke MySQL
Masukan isi database Wiki dari SpeedyWiki ke MySQL


  # mysql -u wikiuser -pwikipassword wikidb < /usr/local/src/wikidb.sql
  # mysql -u wikiuser -pwikipassword wikidb < /usr/local/src/wikidb.sql
Line 56: Line 53:


  # /etc/init.d/mysql restart
  # /etc/init.d/mysql restart
Silahkan akses ke situs Wiki Lokal anda di
  http://localhost/wiki/
==Referensi==
* [[Instalasi MediaWiki]] Cara menginstalasi MediaWiki

Revision as of 02:57, 12 February 2008

Ambil Image dan isi database SpeedyWiki dari http://opensource.telkomspeedy.com/speedyorari/ di folder datawiki

Copykan ke sebuah folder, misalnya, /usr/local/src 

# cp images.tar.gz /usr/local/src/
# cp wikidb.sql.gz /usr/local/src/


Buka dan extract seluruh data 

# cd /usr/local/src
# tar zxvf images.tar.gz
# gunzip wikidb.sql.gz


Copy Image ke folder image di MediaWiki 

# cd /usr/local/src
# cp -Rf /usr/local/src/var/www/html/wiki/images /var/www/wiki/


Lihat konfigurasi MediaWiki, dari file 

# vi /var/www/wiki/LocalSettings.php

Lihat isi parameter berikut 

$wgDBtype           = "mysql";
$wgDBname           = "wikidb";
$wgDBuser           = "wikiuser";
$wgDBpassword       = "wikipassword";


Beri akses wikiuser ke tabel archive dan tabel wikidb 

# mysql -u root -p
Enter password: 

mysql> grant ALL on wikidb.* to wikiuser@localhost;
mysql> grant ALL on archive.* to wikiuser@localhost;
mysql> quit


Masukan isi database Wiki dari SpeedyWiki ke MySQL 

# mysql -u wikiuser -pwikipassword wikidb < /usr/local/src/wikidb.sql

Restart Database MySQL 

# /etc/init.d/mysql restart


Silahkan akses ke situs Wiki Lokal anda di 

 http://localhost/wiki/


Referensi

Retrieved from "https://lms.onnocenter.or.id/wiki/index.php?title=Replikasi_Database_dan_Image_MediaWiki&oldid=1675"