wordpress - WP CLI Not Displaying All Tables -
i trying simple queries figure out how plugin saving information. getting annoying error, , figured out custom template content missing on local. every other setting/content transferred on database export live site. however, reason wp db tables
showing few of tables. checked wp-config, , checked database through sql gui. did wp db check , listed tables. however, wp db tables
giving wrong information, , wp db search
not searching tables reason not display. missing something? (for basic reasons, replaced name of local directory , database name placeholder clientsite).
clientsite % wp db check clientsite.wp_commentmeta ok clientsite.wp_comments ok clientsite.wp_duplicator_packages ok clientsite.wp_email ok clientsite.wp_links ok clientsite.wp_my_calendar ok clientsite.wp_my_calendar_categories ok clientsite.wp_my_calendar_events ok clientsite.wp_my_calendar_locations ok clientsite.wp_options ok clientsite.wp_postmeta ok clientsite.wp_posts ok clientsite.wp_term_relationships ok clientsite.wp_term_taxonomy ok clientsite.wp_termmeta ok clientsite.wp_terms ok clientsite.wp_usermeta ok clientsite.wp_users ok clientsite.wp_woocommerce_api_keys ok clientsite.wp_woocommerce_attribute_taxonomies ok clientsite.wp_woocommerce_downloadable_product_permissions ok clientsite.wp_woocommerce_order_itemmeta ok clientsite.wp_woocommerce_order_items ok clientsite.wp_woocommerce_payment_tokenmeta ok clientsite.wp_woocommerce_payment_tokens ok clientsite.wp_woocommerce_sessions ok clientsite.wp_woocommerce_shipping_zone_locations ok clientsite.wp_woocommerce_shipping_zone_methods ok clientsite.wp_woocommerce_shipping_zones ok clientsite.wp_woocommerce_tax_rate_locations ok clientsite.wp_woocommerce_tax_rates ok clientsite.wp_wpc_client_categories ok clientsite.wp_wpc_client_chains ok clientsite.wp_wpc_client_clients_page ok clientsite.wp_wpc_client_file_categories ok clientsite.wp_wpc_client_files ok clientsite.wp_wpc_client_files_download_log ok clientsite.wp_wpc_client_group_clients ok clientsite.wp_wpc_client_groups ok clientsite.wp_wpc_client_login_redirects ok clientsite.wp_wpc_client_messages ok clientsite.wp_wpc_client_objects_assigns ok clientsite.wp_wpc_client_payments ok clientsite.wp_wpc_client_portal_page_categories ok clientsite.wp_wpuf_transaction ok success: database checked.
wp cli tables command gives following:
clientsite % wp db tables wp_users wp_usermeta wp_posts wp_comments wp_links wp_options wp_postmeta wp_terms wp_term_taxonomy wp_term_relationships wp_termmeta wp_commentmeta wp_woocommerce_payment_tokenmeta wp_woocommerce_order_itemmeta
wp-config.php contains below.
clientsite % cat wp-config.php define('db_name', 'clientsite');
found answer. after more specific google searching , needing use quotes (originally kept returning wp-cli docs page), found on github issues page. apparently wp db tables
finds default tables registered $wpdb, , not tables in database. resolved using --all-tables
@ end of commands.
for reference: https://github.com/wp-cli/wp-cli/issues/2474
Comments
Post a Comment