noelrocha · December 19, 2011 22:57
diff --git a/export_mysql_privileges.sh b/export_mysql_privileges.sh
 mysql -u [USER] -p[PASSWORD] -B -N $@ -e "SELECT DISTINCT CONCAT(
   'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
   ) AS query FROM mysql.user" | \
 mysql -u [USER] -p[PASSWORD] $@ | \
 sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
	mysql -u [USER] -p[PASSWORD] -B -N $@ -e "SELECT DISTINCT CONCAT(
	'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
	) AS query FROM mysql.user" \| \
	mysql -u [USER] -p[PASSWORD] $@ \| \
	sed 's/\(GRANT .\)/\1;/;s/^\(Grants for .\)/## \1 ##/;/##/{x;p;x;}'