on 12/17/02 6:20 PM, Daevid Vincent at [EMAIL PROTECTED] appended the
following bits to my mbox:

> This method copies the data, but doesn't copy 'Extra' stuff like
> "auto_increment".

I've used the following before:


You could probably do something like this.

1) Pick the database (SHOW DATABASES);

2) Create new database

3) List the tables in the database (SHOW TABLES FROM $database)

4) For each table in the database, do the following:

    a) SHOW CREATE TABLE $tablename
    b) perform the above query on the new database

    c) transfer the data

If the databases are on the same server, I think you can do (c) as the

INSERT INTO $new_database.$tablename SELECT * FROM $old_database.$tablename;

If it's a remote server, I think it would require you to do it in PHP

Hope that helps.


Paul Burney

    while ($self != "asleep") {

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to