Using PHP to copy tables from one Mysql DB to another

[SpacePhoenix]

@wh33t

Yes, both source and destination databases are on the same Mysql Server, but they required different usernames and logins. Could you give an example of how I might pull off what you suggested? I’d really appreciate that.

Does one of the to users have rights to do SELECT queries on the tables in the source database and INSERT queries in the destination database? If so have PHP use that user to copy the data across, but running the query against the destination database.

Thread moved to the Databases forum