# Create a new database and duplicate tables one by one CREATE DATABASE db_name; CREATE TABLE x LIKE other_db.y;