Karen Schaefer
asked on
New to MYSql - copy table data from one schema to another with new tables
I am new to MySQL - looking for the easiest approach to moving data from one schema to another - with limited tables.
I already created blank tables with indexes and now I need to import or copy the data from the old schema. What is the best approach?
I already created blank tables with indexes and now I need to import or copy the data from the old schema. What is the best approach?
ASKER
How can I limit which tables to include in the migration. My second db has only a few tables compared to the original?
ASKER
How do I create a new schema, transfer certain tables with indexes, columns, & data from old schema to new schema.
What is the simplest approach. I tried Migration wizard without success - Migration fails part way thru the process?
What is the simplest approach. I tried Migration wizard without success - Migration fails part way thru the process?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the great input.
in MySQL? then probably you can try the MySQL Workbench's migration wizard.
just follow the steps provided in the wizards or referring to the articles below:
10.8 Using the MySQL Workbench Migration Wizard
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard.html
you can download MySQL Workbench from MySQL website:
http://dev.mysql.com/downloads/workbench/