Copying Database using PHP

[stockwet]

I'm developing a web application that requires my duplicating a master database for different customers. In other words, I want to ensure that each customer has their own db setup, all based on a master structure, without having to write-out all of the create db code.

I'd like to use PHP to simply copy the master db and rename it. The only scripts I've found require using a shell. I want the customer to be able to automatically setup their account without intervention from me. This means that they fill out a form and the db gets created when they press submit. The MySql server is being hosted, so the shell option is out. Any ideas on this?

[Anon]

You may be able to the shell commands needed to do this from PHP, even if you do not have direct access a shell yourself.

I have php scripts which are not much more than a wrapper for a group of shell commands.

-Pete

[zone16]

Will the clients have access to the database, or just access to an interface to the db. If it's the latest, I suggest you create a client table, and add a client id to all your other tables.
That way, if you make a change to your db, you won't have to replicate it to all your clients db...

Good luck anyway...