Reverse Engineering a large SQL script
So I have a huge database that has 1508 tables and is 10GB in size. I ran a MySQLDump to create a backup. I have checked this backup and it has 1506 create table statements in it.
I then open up MySQL Workbench 6.0 and create new model. I press "file" > "Import" > "Reverse Engineer...". I browse to my .sql file that I got from MySQLDump and let it run. At the end of the import I only have 1024 tables of the 1508 that should be there.
If I take it to the next step and connect the schema to a local host it only brings 48 of the tables.
Why am I loosing tables as I deploy locally?
Subject
Views
Written By
Posted
Reverse Engineering a large SQL script
1528
July 01, 2015 07:33AM
504
July 02, 2015 03:12AM
476
July 02, 2015 03:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.