Oracle Database
--
Questions
--
Followers
Top Experts
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?
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
>>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/
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/
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?
What is the simplest approach. Â I tried Migration wizard without success - Migration fails part way thru the process?
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks for the great input.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.