The main problem with a direct import is that most rows in MySQL have an auto-incrementing ID, so old data will have ID conflicts with the new data.
The solution I found was to add a large value (e.g. 10 million) to the rows in the new data, before importing the old one.
Is there a better solution for such cases?
The main problem with a direct import is that most rows in MySQL have an auto-incrementing ID, so old data will have ID conflicts with the new data.
The solution I found was to add a large value (e.g. 10 million) to the rows in the new data, before importing the old one.
Is there a better solution for such cases?