rename or copy database

create database new_db;
use new_db;

for all tables in old_db:
create table tableN like old_db.tableN;
insert into tableN select * from old_db.tableN