title: Copy a database with data in MySQL
body: <p>I have a base set of data held in a database on my server. When a user signs up for my service, I want to be able to copy this database to another database that has been created. Is there a simple and effective way to do this using PHP / MySQL? Pure MySQL would be preferable. </p>
  
  <p>I thought about looping through all the tables in the base database but I wouldn't know how to then create that table with columns to the new database.</p>
  
  <p>Running PHP 5.1 and MySQL 5.</p>
  
  <p>Thanks.</p>