CODEWITHSUNDEEP
xmlpostgresqlmediawikidatabase-backups
Aamir
Aamir

Reputation: 758

how to take backup from wiki and import in postgresql?

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.

Upvotes: 3

Views: 2065

Answers (1)

Ilmari Karonen
Ilmari Karonen

Reputation: 50328

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.

Upvotes: 2

Related Questions