• Resolved natekolvek

    (@natekolvek)


    My question is essentially 2 parts for 1 answer. I have several exports of a large database with (it appears) 2011 products. There was a problem with actionscheduler that was writing several thousand lines every minute to actionscheduler logs (or roughly 3.5 million lines every 24 hours). I’ve reconstructed another db with all the tables used by woocommerce, or so I believe. The list of tables are:

    _options
    _postmeta
    _posts
    _termmeta
    _terms
    _term_relationships
    _term_taxonomy
    _woocommerce_shipping_zones
    _woocommerce_shipping_zone_locations
    _woocommerce_shipping_zone_methods
    _woocommerce_tax_rates
    _woocommerce_tax_rate_locations

    Am I missing any tables for a complete, non-plugin export of all products, categories, tags, meta, image links and attachments/links and how would that query be crafted? I’ve looked around but can find no single query posted that has all data required, just those that do almost all but are missing say, image links… I used a woo exporter and it did not include categories and image links so importing just gave me all the products and descriptions. I can pull directly from the wonky db I dumped to reconstruct everything I need. I’m assuming the query I need will also fix the problem of products not importing to any category. I can verify that that information is in fact in the wonky DB.

    Thanks in advance!


Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘query external database’ is closed to new replies.