Link to home
Start Free TrialLog in
Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America

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?
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

>>easiest approach to moving data from one schema to another

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/
Avatar of Karen Schaefer

ASKER

How can I limit which tables to include in the migration.  My second db has only a few tables compared to the original?
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?
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the great input.