Export Query?

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: export, query

Author

Posts
February 24, 2018 at 2:21 am #419003

Bradley
Expired Member

Post count: 16

I have a very large directory, and it would be helpful if I could export the listings directly from the DB. Could you provide the query for those of us that might want to do this on our own? It takes forever using the built in export feature.

February 24, 2018 at 2:33 am #419004

Guust
Moderator

Post count: 29970

I’ll get a developer to look at your question. Thanks.

February 24, 2018 at 10:33 am #419043

Stiofan O’Connor
Site Admin

Post count: 22956

I have never head anyone complain about the export taking a while, do you maybe mean import?
The info has to be pulled from a few tables but if you don’t need image info you can pull it from just 2.

Let me know what you are trying to do and i’ll let you know the best way to do it.

Thanks,

Stiofan

February 24, 2018 at 1:24 pm #419065

Dirk
Full Member

Post count: 390

@bradley,

what do you call a very large directory?

Two months ago I exported one of my CPTs with about 35.000 listings without any issue.

February 24, 2018 at 5:15 pm #419114

Bradley
Expired Member

Post count: 16

I have 55,000 listings. I did figure out that if I exported them into smaller batches, it goes much smoother. Regardless, it would still be nice to have the ability to query this from the database myself. I supposed I can figure this out myself, but thought it would be a no-brainer for your developers to share.

February 24, 2018 at 10:16 pm #419130

Dirk
Full Member

Post count: 390

Stiofan already asked if you need to also export images. If not it is much easier to do and the GD team will give you the hints.

You should tune your SQL database. Typically, after installation the parameters are very conservative and not performing under heavy load (like the export is).

February 25, 2018 at 9:47 pm #419177

Bradley
Expired Member

Post count: 16

No images required. Any hints would be greatly appreciated.

February 26, 2018 at 11:23 am #419251
Stiofan O’Connor
Site Admin

Post count: 22956
It would be somthing like this:
```
SELECT * FROM 'wp_geodir_gd_place_detail' pd  LEFT JOIN 'wp_posts' p ON pd.post_id=p.ID WHERE 1=1
```
Stiofan
February 26, 2018 at 12:39 pm #419260

Bradley
Expired Member

Post count: 16

Thanks!
Author

Posts