I have a database that I want to make a copy of. I export all of the tables as SQL and then import them into a new blank database on the same server. During the import, I receive lots of errors on multiple tables complaining about "Duplicate entry xyz for key 'Primary'. When I look at the tables, I can see that the restored database has tables with fewer rows.
How is this possible since the I'm creating the tables during the import and it has the same structure and data as the original tables? I'm very confused.