Auto_increment problem while export-import

[Anurag Sharma]

Hello,

I have a problem that I googled for but couldn't get any resolution.

I have 4 databases with 2 columns and a single central database with the same 2 columns. I want to put all the data from all the 4 databases into the central database. In my tables I have auto_increment field (id). When I export the data the id field too gets exported with its values. When I try to import it in the central DB then it gives problems. My central DB's auto_increment id field clashes with the id field of my other database tables.

So, how can I perform this operation? I thought maybe there is a way to avoid auto_increment field while exporting but there is none.

Please help me since this is very urgent.

Thanks a lot in advance.

Anurag