#!/bin/bash unalias ls cd /var/lib/mysql newuser="postersf" for db in foodand_*; do dbname=$(echo $db | cut -d "_" -f 2-) newdb=${newuser}_$dbname #cmd="mysqldump --opt ${db} | mysql ${newdb}" #$cmd mysql -e "create database ${newdb}" mysqldump --opt ${db} | mysql ${newdb} done