A handy script to stream a MySQL dump into another database.

migrate.sh

#!/bin/bash

SOURCE_USER=user
SOURCE_HOST=localhost
SOURCE_PASSWORD='password'
SOURCE_DATABASE=database

TARGET_USER=user
TARGET_HOST=localhost
TARGET_PASSWORD='password'
TARGET_DATABASE=database

mysqldump $SOURCE_DATABASE --user=$SOURCE_USER --host=$SOURCE_HOST --password=$SOURCE_PASSWORD | \
mysql --user=$TARGET_USER --host=$TARGET_HOST --password=$TARGET_PASSWORD $TARGET_DATABASE