gjedeer · August 22, 2012 06:14
diff --git a/gistfile1.sh b/gistfile1.sh
 #!/bin/bash
 #
 # mass change prefixes in Joomla database
 # massivescale.net 2012
 #

 echo "SELECT concat('rename table ', table_name, ' to ', 'iddqd', substr(table_name,4), ';') FROM information_schema.tables WHERE table_name like 'jos%';" |  mysql | tail -n +2 | mysql `grep db\  /var/www/configuration.php | awk -F"'" '{print $2}'`
 sed -i -e 's/jos_/iddqd_/' /var/www/configuration.php
	#!/bin/bash
	#
	# mass change prefixes in Joomla database
	# massivescale.net 2012
	#

	echo "SELECT concat('rename table ', table_name, ' to ', 'iddqd', substr(table_name,4), ';') FROM information_schema.tables WHERE table_name like 'jos%';" \| mysql \| tail -n +2 \| mysql `grep db\ /var/www/configuration.php \| awk -F"'" '{print $2}'`
	sed -i -e 's/jos_/iddqd_/' /var/www/configuration.php