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.
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.
Running PHP 5.1 and MySQL 5.