Do an export from db1 and import into db2 with ignore=y.
You could create the indexes fresh in db2 after the import.
BTW, do not forget to analyze the schema.
HTH.
|
Results 1 to 3 of 3
Thread: bulk insert & rebuild indexesThreaded View
|
Click Here to Expand Forum to Full Width |