Trying to Duplicate a DB... much frowning

[ablemike]

I am writing a script to duplicate dynamic sites that all run from the same server.

I have all assets of the management done except for one final thing.

I need to make a form that will duplicate a mysql database to a new database with the name coming from a form variable.

I have scoured the web for the answer and as you can imagine a Google search like duplicate mysql database results in nothing relevant to the task at hand.

One avenue i thought to try was mysqldump -quick to dump the database to a text file and then open that dump to create a new one. This seams to be a convoluted theory though.

Does anyone have any scripts that will do what I am attempting? Or even better, a link to some logic?

Thanks In Advance!
Mike - St. Louis MO

[meigwil]

I'm no expert, but here are a few things you could look into further.

include 'connect.php';

$sql = "SHOW TABLES";

$result = mysql_query($sql) or die ("Error - ".mysql_error());

You now have all your table names in the $result array.

Then:

$table = 'tablename';

$sql2 = "DESCRIBE ".$table;

$result2 = mysql_query($sql) or die ("Error - ".mysql_error());

You now have all the table's fields in the $result2 array.

Using these and a "SELECT * FROM ".$table I'm sure you could write the database's contents to another database.

Can't help you with creating that one though. :bemused:

Mei

[MarkR]

The normal way of doing this is to use a database dump, then feed this back into the mysql command line client. Try it out yourself on your dev box.

If you're being really clever, you don't even need a dump file, you can put it straight from mysqldump back into mysql with a pipe.

Mark

[ablemike]

I found an easier way. Wrote a shell script to duplicate the necesary folders and database files 🙂 Go figure 🙂