Index: head/textproc/mysqlviz/Makefile
===================================================================
--- head/textproc/mysqlviz/Makefile	(revision 436966)
+++ head/textproc/mysqlviz/Makefile	(revision 436967)
@@ -1,37 +1,37 @@
 # Created by: TAKATSU Tomonari <tota@FreeBSD.org>
 # $FreeBSD$
 
 PORTNAME=	mysqlviz
 PORTVERSION=	0.3
+PORTREVISION=	1
 CATEGORIES=	textproc
-MASTER_SITES=	GOOGLE_CODE
 
 MAINTAINER=	tota@FreeBSD.org
 COMMENT=	MySQL and SQLite Database Visualisation Tool
 
 LICENSE=	GPLv3
 
-BROKEN=		Unfetchable (google code has gone away)
-DEPRECATED=	Unfetchable for more than six months (google code has gone away)
-EXPIRATION_DATE=	2017-04-30
-
 NO_BUILD=	yes
 USES=	php:cli tar:bzip2
+USE_GITHUB=	yes
+GH_ACCOUNT=	globalcitizen
 
 PLIST_FILES=	bin/${PORTNAME}
 
 PORTEXAMPLES=	eg.png eg.sql sqlite-eg.sql
 
 OPTIONS_DEFINE=	EXAMPLES
 
 post-patch:
 	@${REINPLACE_CMD} \
 		-e 's|/usr/bin/php|${LOCALBASE}/bin/php|' \
 		${WRKSRC}/${PORTNAME}
 
 do-install:
 	${INSTALL_SCRIPT} ${WRKSRC}/${PORTNAME} ${STAGEDIR}${PREFIX}/bin
+
+do-install-EXAMPLES-on:
 	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
 	cd ${WRKSRC} && ${INSTALL_DATA} ${PORTEXAMPLES} ${STAGEDIR}${EXAMPLESDIR}
 
 .include <bsd.port.mk>
Index: head/textproc/mysqlviz/distinfo
===================================================================
--- head/textproc/mysqlviz/distinfo	(revision 436966)
+++ head/textproc/mysqlviz/distinfo	(revision 436967)
@@ -1,2 +1,3 @@
-SHA256 (mysqlviz-0.3.tar.bz2) = fdfc89771b821dfa6e9dda7a189d9f6d7db22a0bedb8450ba96dc08cf0221d8e
-SIZE (mysqlviz-0.3.tar.bz2) = 15377
+TIMESTAMP = 1490527116
+SHA256 (globalcitizen-mysqlviz-0.3_GH0.tar.gz) = 0e95b85258ca8908c59459eaf170176d34ac70b1f4cc5ffbd216640037c5f89f
+SIZE (globalcitizen-mysqlviz-0.3_GH0.tar.gz) = 14749
Index: head/textproc/mysqlviz/files/patch-mysqlviz
===================================================================
--- head/textproc/mysqlviz/files/patch-mysqlviz	(revision 436966)
+++ head/textproc/mysqlviz/files/patch-mysqlviz	(revision 436967)
@@ -1,25 +1,25 @@
---- mysqlviz.orig	2010-11-13 08:54:02.000000000 +0900
-+++ mysqlviz	2013-05-06 17:56:14.000000000 +0900
-@@ -184,17 +184,16 @@
+--- mysqlviz.orig	2010-11-12 23:53:55 UTC
++++ mysqlviz
+@@ -184,17 +184,16 @@ exit(0);
  
  # usage information
  function usage() {
 - global $argv;
 - print '[' . basename($argv[0]) . " - mysql + sqlite database visualisation tool]\n\n";
 + print "[mysqlviz - mysql + sqlite database visualisation tool]\n\n";
   print "usage:\n";
 - print "  " . $argv[0] . " -f <sqldumpfile> [-r]\n";
 - print "                                 ^--- 'redump' mode: generates a\n";
 - print "                                      mysqldump command line to redump.\n";
 + print "  mysqlviz -f <sqldumpfile> [-r]\n";
 + print "                               ^--- 'redump' mode: generates a\n";
 + print "                                    mysqldump command line to redump.\n";
   print "toolchain:\n";
   print " $ mysqldump -d db >db.sql          # MySQL: -d = 'no data', only structure\n";
   print "    - OR -\n";
   print " $ sqlite database.db .dump >db.sql # SQLite (also: 'sqlite3 ...')\n";
 - print " $ $argv[0] -f ./db.sql >./db.dot # 'dot' is a graphviz format.\n";
 + print " $ mysqlviz -f ./db.sql >./db.dot # 'dot' is a graphviz format.\n";
   print " $ dot -Tpng db.dot >db.png         # generate image with graphviz\n\n";
   print "notes:\n";
   print " if you do not have any foreign keys defined, relationships will be\n";
Index: head/textproc/mysqlviz/pkg-descr
===================================================================
--- head/textproc/mysqlviz/pkg-descr	(revision 436966)
+++ head/textproc/mysqlviz/pkg-descr	(revision 436967)
@@ -1,9 +1,9 @@
 Render a graphical representation of a MySQL or SQLite database
 from a mysqldump or sqlite3 .dump file.
 
 Features:
 - Can infer foreign key relationships if you do not have them defined
 - Handles partial dumps (FK to tables that are not defined within the dump)
 - Fast! Uses sed and grep for data extraction (MySQL only)
 
-WWW: http://code.google.com/p/mysqlviz/
+WWW: https://github.com/globalcitizen/mysqlviz