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?
Topic on Project:Support desk
Appearance
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.
Thanks for the clear advice!
I ended up using Extension:MassEditRegex, which worked fine.