You can do it the "hard" way ... The idea is to query INFORMATION_SCHEMA database in such a way that the resulting result is a valid SQL string that you can simply run.
I don't have a full article talking about exactly what you want ... but this one will give you pretty much the same idea:
Microshell Comparing data from 2 database tables
I'd imagine you'll write queries something like this:
Code:
SELECT
CONCAT('CREATE TABLE DB2.', TABLE_NAME, ' LIKE ', TABLE_SCHEMA, '.', TABLE_NAME, ';') AS create_table_sql,
CONCAT('INSERT INTO DB2.', TABLE_NAME, ' SELECT * FROM ', TABLE_SCHEMA, '.', TABLE_NAME, ';') AS populate_table_sql
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'DB1'
;
Then once you get the result, simply copy, paste and run the SQLs.
dBforums
>
How to copy a database
How to copy a database
10-15-09, 09:47
Linear Mode
