Export Query?

This topic contains 8 replies, has 4 voices, and was last updated by  Bradley 6 years, 2 months ago.

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

Open Support Ticket

Tagged: ,

  • 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
Viewing 9 posts - 1 through 9 (of 9 total)

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

Open Support Ticket