Results 1 to 10 of 10

Thread: Delete All Listing with SQL

  1. November 28th, 2013 #1
    mfbrummett
    mfbrummett is offline
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete All Listing with SQL

    I have over 20,000 listings that I imported (yes that took a while using small file sizes) and I would like to use SQL to quickly delete them so I can redo my listings. I am new to WordPress and PHP but I have worked with SQL for over 13 years so I do feel comfortable with SQL. I did do a backup before I loaded the listings, but I added some pages that I don't want to drop so I was hoping for a fast SQL alternative to remove the listings.

    I appreciate the help!
    Reply With Quote Reply With Quote
  2. November 28th, 2013 #2
    red20me
    red20me is offline
    red20me's Avatar
    Join Date
    Jul 2013
    Location
    United Kingdom
    Posts
    473
    Thanks
    1
    Thanked 104 Times in 93 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  3. November 28th, 2013 #3
    mfbrummett
    mfbrummett is offline
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  4. November 29th, 2013 #4
    mfbrummett
    mfbrummett is offline
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  5. November 29th, 2013 #5
    red20me
    red20me is offline
    red20me's Avatar
    Join Date
    Jul 2013
    Location
    United Kingdom
    Posts
    473
    Thanks
    1
    Thanked 104 Times in 93 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  6. November 29th, 2013 #6
    junnydc
    junnydc is offline
    Senior Member junnydc's Avatar
    Join Date
    Aug 2011
    Location
    Singapore
    Posts
    198
    Thanks
    20
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Wordpress Premium Theme 2015 | Wordpress Step By Step Tutorial | Business Directory | Philippines Free Ads | Free Classified Ads
    Reply With Quote Reply With Quote
  7. November 29th, 2013 #7
    dimitris
    dimitris is offline
    dimitris's Avatar
    Join Date
    Oct 2011
    Location
    Earth
    Posts
    20,617
    Thanks
    222
    Thanked 1,873 Times in 1,770 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  8. November 29th, 2013 #8
    mfbrummett
    mfbrummett is offline
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  9. November 29th, 2013 #9
    joes
    joes is offline
    joes's Avatar
    Join Date
    Nov 2012
    Location
    Australia
    Posts
    877
    Thanks
    12
    Thanked 358 Times in 261 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  10. November 30th, 2013 #10
    mfbrummett
    mfbrummett is offline
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
« Maps not showing since installing W3 Total Cache plugin | Longitude and Latitude »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Is there a delete listing option in Vantage 1.1.1
    By mediacomnc in forum Vantage General Discussion (Legacy)
    Replies: 7
    Last Post: March 15th, 2015, 01:51 AM
  2. Dimitris listing owner - delete own listing
    By tradeamillion in forum Help Using Vantage (Legacy)
    Replies: 4
    Last Post: November 20th, 2013, 04:30 PM
  3. Delete listing in Vantage does not delete the geodata
    By joes in forum Report Vantage Bugs (Legacy)
    Replies: 4
    Last Post: November 29th, 2012, 09:55 PM
  4. How to delete /Ad Category/ &/Ad Listing/ in the Url
    By tech9 in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: April 12th, 2012, 08:58 AM
  5. Single Ad Listing (Sidebar): Delete Subcategories box
    By lcolley in forum ClassiPress General Discussion
    Replies: 2
    Last Post: August 13th, 2010, 01:21 PM