User:Revansx/GePhi/How to export all Page links as a CSV for import into GePhi

Tailor and Test the basic SQL
This code assumes a wiki database named "wiki_demo". Tailor this for your wiki database and paste it into the mysql cli on your server and make sure it runs without error and produces the expected output (a table of page links with both source and destination info)

Test the SQL code that produces formatted output
Make whatever changes you made to the SQL above to the nested SQL select below and you should get similar results from the mysql cli but just formatted like we want for GePhi import