Originally posted by learning_bee
Here is the approach I have in mind but I am not sure this is the best approach so please give me your opinion:

1. do a full export with no data
2. export the 100 tables with data.
3. do a full import to the new schema.
4. import the 100 tables with ignore=y

any other thoughts????
Sounds good to me but..

You may want to save the index builds for last, after the data is loaded.

No?

MH