Duplicating A Database

It would be nice to be able to duplicate a database for a new database that is going to have the same columns.

Have you tried exporting the database, then importing it back in as a new database?