how to take backup from wiki and import in postgresql?

Question

I have to perform backup from wikimedia database and import that data into postgresql. I was googling about it but got no solution.

I am not asking for solution here. All I want is idea that how I can copy data from wikimedia and import the same into postgresql. Of course data will be in xml format.

I know it might be wrong question but what's wrong in try.

Did you see these links ? mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup mediawiki.org/wiki/Manual:Backing_up_a_wiki#PostgreSQL — Seyed Hamed Shams
– Seyed Hamed Shams, Commented Jan 18, 2014 at 3:22
So far I found that using mwdumper.jar from [here][1] with: java -jar mwdumper.jar --format=sql:1.4 acurrentpagesxmldump.bz2 > thesqlcommand.sql and a different output with: java -jar mwdumper.jar --format=sql:1.4 acurrentpagesxmldump.bz2 > thesqlcommand5.sql produces an SQL command, possibly valid for PostgreSQL. Not validate since this requires the creation of tables which I have not created [1]: code.google.com/archive/p/wikitrust/downloads — ilias iliadis
– ilias iliadis, Commented Jul 22, 2018 at 7:01

Ilmari Karonen · Accepted Answer · 2015-02-17 04:54:43Z

2

If you're trying to import an XML data dump from Wikipedia or some other wiki running MediaWiki, just follow these instructions — most of the methods described on that page should work just as well on PostgreSQL as on MySQL.

If you're trying to import an SQL dump file for some reason, you'll need to convert it from MySQL to PostgreSQL format first. Note that, if you're simply trying to import content from Wikipedia or another Wikimedia wiki, you shouldn't need to do this — the XML dumps should contain everything you need.

edited Feb 17, 2015 at 4:54

answered Jan 17, 2014 at 13:39

Ilmari Karonen

50.5k9 gold badges96 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kutschkem Over a year ago

Your last link is broken.

Ilmari Karonen Over a year ago

Looks like that thread got deleted. Replaced it with a wiki link.

Collectives™ on Stack Overflow

how to take backup from wiki and import in postgresql?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related