query external database
-
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_locationsAm 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!
The topic ‘query external database’ is closed to new replies.