Wikipedia pagelinks postgres import; fixes up MySQL format problems that interfere with psql. Imports into the wiki database as `postgres`.

import.sh

#!/usr/bin/env bash

pv enwiki-20151102-pagelinks.sql.gz |  zcat  | ./sql.pl  | sudo -u postgres psql wiki >psql_err.log 2>&1

sql.pl

#!/usr/bin/env perl
print("SET standard_conforming_strings = 'off';\n");
print("SET backslash_quote = 'on';\n");
$nr = 0;
while(<>){
	s/`/"/g if ($nr < 39);
	s/int\(\d+\)( unsigned)?/INTEGER/g;
	s/UNIQUE KEY "\w+"/UNIQUE/g;
	s/ENGINE=InnoDB DEFAULT CHARSET=binary//;
	s/varbinary\(255\)/TEXT/g;
	s/KEY "\w+"/UNIQUE/g;
	s/`PAGELINKS`/pagelinks/ig;
	s/\\"/"/g;
	s/\\'/''/g;
	print;
	$nr = $nr + 1;
}