Mass-change database prefixes in Joomla!

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