Topic on Project:Support desk

Export sql file, modify offline, import again = good idea?

3
Stefahn (talkcontribs)

I need to do complex regex replacements in my wikitext (which I can't do via Extension:ReplaceText). Is it a good idea to export the sql file, modify it offline (via Notepad++), and import the altered file again in my database?
Or do I corrupt the database doing so?

Ciencia Al Poder (talkcontribs)

You're going to corrupt your database. Also, that massive replace will do the replaces also on old versions of pages, not only the current one, without giving any hint on the page history.

You should try to use Pywikibot. It's relatively easy to set up and comes with scripts to do replacements.

Stefahn (talkcontribs)