Home Forums Event Espresso Premium Best way to get a FULL export of event data?

Best way to get a FULL export of event data?

Posted: July 1, 2012 at 5:18 pm


July 1, 2012 at 5:18 pm

I’ assuming that the best way to get a full event data export is to export/import the tables using phpMyAdmin, however, when I do this it keeps telling me:

#1062 – Duplicate entry ‘1’ for key ‘id’

What is the best way to do the sql export/import process to avoid getting this error?


  • Support Staff

July 2, 2012 at 10:11 am

Which table(s) are you exporting? I would say that you should check for a duplicate entry for the id key in one of those first.


July 2, 2012 at 10:24 am

Well I first was looking at exporting the events_detail and then any others as needed. The table I’m importing into, however, is empty so that’s what I don’t get about the duplicate id error.

I tried using the events.csv from “export all event data”, but it was quite incomplete in transferring over info.


  • Support Staff

July 2, 2012 at 3:26 pm

We have a new exporter under development that should be released with 3.3, which will allow customized exports, so you’ll be able to choose what gets exported.

As far as the error you are getting goes, I’m not sure why that would happen if you’re importing this into an empty table. From what I understand, that would happen if there was already a value for that key.


July 3, 2012 at 2:53 pm

that will be a great addition.

The support post ‘Best way to get a FULL export of event data?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso