|
-
How about export the 100 tables that need data but do it with indexes=n and constraints=no.
then do a full export with indexes and constraints but no data.
import the export with the data.
then do the other import with ignore=y?
or you can just restore you latest backup to the new server and truncate the tables that need truncated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|