Copy a MySQL database into another database

mysql -u root -p -e 'CREATE DATABASE shop_staging DEFAULT CHARACTER SET utf8'
mysqldump --single-transaction --routines -u root -p shop | mysql -u root -p shop_staging