Import SQL data on an existing server

2 XCSme 1 7/22/2025, 2:29:49 PM docs.uxwizz.com ↗

Comments (1)

XCSme · 7h ago
A client asked me to help them import MySQL analytics data over to a DB that already had data in it.

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?