Add a prefix on tables of a SQL dump

add_prefix_sql.sh

#!/bin/sh
#
# Simple script for setting table prefixes in SQL-dump
if [ $# != 2 ]; then
	cat >&2 << EOH
This is Drupal database prefixer.
Usage:
  $0 prefix original_db.sql > prefixed_db.sql
- all tables will be prefixed with 'prefix'
EOH
	exit 1;
fi
PRFX=$1;
sed "s/^CREATE TABLE /CREATE TABLE $PRFX/i;
     s/^INSERT INTO /INSERT INTO $PRFX/i;
     s/^REPLACE /REPLACE $PRFX/i;
     s/^ALTER TABLE /ALTER TABLE $PRFX/i" $2