Backup from db only wpgeo files

This topic contains 2 replies, has 2 voices, and was last updated by  Alec 9 years, 8 months ago.

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

Open Support Ticket

Tagged: , , ,

  • Author
    Posts
  • March 30, 2015 at 11:12 pm #35640

    Alec
    Lifetime Member
    Post count: 319

    Does anyone have a tool or an foolproof method to backup the wordpress database and get only the wpgeodirectory rows in tables for wpgeo listings? I think I have a corrupt database due to several themes and several plugins that inhabited the db and I want to reload WP as well as GeoDir from a fresh install without losing the listings.

    March 30, 2015 at 11:58 pm #35646

    Simone
    Expired Member
    Post count: 3515

    Hello, unfortunately it is not so easy and foolproof, because GD uses also wordpress tables, (postmeta etc..) so it might result in a broken website.
    You could export al the wp_geodir* tables, but in the fresh install you need to have the, for example, the same categories (with the same ID) you have on the “old” website. The best choice should be to have a csv of the listings to be uploaded on the new installation

    March 31, 2015 at 4:09 am #35667

    Alec
    Lifetime Member
    Post count: 319

    Yes, the id is tricky but I can always auto increment above xxxx. Our tables are starting at around 5800 so that is a very high number to start an auto increment at. The csv is OK but there just is not a WP tool for this that passes mustar. It sure would be nice if the goedir tables could contain all the data and not share them with WP. Unfortunately this may be why many people don’t liek using WP for “plugins.”

    Thanks for your suggestions. I’m about ready to build my own directory—not a plugin. There are just too many restriction with WP.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount