How to get list of ALL tables in the database?

This answers my question. But it’s not in terms of PHP code. I used the mysql command line client, once I figured out how to run it in my godaddy hosted WordPress environment:

The wp-config.php file has the DB_NAME, DB_USER, and DB_PASSWORD. And
the DB_HOST needs to be split at the “:” character to get the IP
address for the -h argument and the port number for the -P argument.
[I later learned that logging in to my godaddy account and accessing
its managed WordPress product gives a link to phpMyadmin, which
obviates the need to use the mysql command line client.]

Having gotten to the mysql command line prompt with the DB_NAME as the database in use, a simple show tables; does the trick:

MySQL [g5mb45616650937E]> show tables
+--------------------------------------------+
| Tables_in_g5mb45616650937                  |
+--------------------------------------------+
| wp_6hanxjxbpv_actionscheduler_actions      |
| wp_6hanxjxbpv_actionscheduler_claims       |
| wp_6hanxjxbpv_actionscheduler_groups       |
| wp_6hanxjxbpv_actionscheduler_logs         |
| wp_6hanxjxbpv_booking                      |
| wp_6hanxjxbpv_booking_dates_props          |
| wp_6hanxjxbpv_bookingdates                 |
| wp_6hanxjxbpv_bp_activity                  |
| wp_6hanxjxbpv_bp_activity_meta             |
| wp_6hanxjxbpv_bp_friends                   |
| wp_6hanxjxbpv_bp_groups                    |
| wp_6hanxjxbpv_bp_groups_groupmeta          |
| wp_6hanxjxbpv_bp_groups_members            |
| wp_6hanxjxbpv_bp_invitations               |
| wp_6hanxjxbpv_bp_messages_messages         |
| wp_6hanxjxbpv_bp_messages_meta             |
| wp_6hanxjxbpv_bp_messages_notices          |
| wp_6hanxjxbpv_bp_messages_recipients       |
| wp_6hanxjxbpv_bp_notifications             |
| wp_6hanxjxbpv_bp_notifications_meta        |
| wp_6hanxjxbpv_bp_optouts                   |
| wp_6hanxjxbpv_bp_user_blogs                |
| wp_6hanxjxbpv_bp_user_blogs_blogmeta       |
| wp_6hanxjxbpv_bp_xprofile_data             |
| wp_6hanxjxbpv_bp_xprofile_fields           |
| wp_6hanxjxbpv_bp_xprofile_groups           |
| wp_6hanxjxbpv_bp_xprofile_meta             |
| wp_6hanxjxbpv_commentmeta                  |
| wp_6hanxjxbpv_comments                     |
| wp_6hanxjxbpv_e_events                     |
| wp_6hanxjxbpv_links                        |
| wp_6hanxjxbpv_options                      |
| wp_6hanxjxbpv_postmeta                     |
| wp_6hanxjxbpv_posts                        |
| wp_6hanxjxbpv_prflxtrflds_field_values     |
| wp_6hanxjxbpv_prflxtrflds_fields_id        |
| wp_6hanxjxbpv_prflxtrflds_fields_meta      |
| wp_6hanxjxbpv_prflxtrflds_roles_and_fields |
| wp_6hanxjxbpv_prflxtrflds_roles_id         |
| wp_6hanxjxbpv_prflxtrflds_user_field_data  |
| wp_6hanxjxbpv_prflxtrflds_user_roles       |
| wp_6hanxjxbpv_signups                      |
| wp_6hanxjxbpv_tec_events                   |
| wp_6hanxjxbpv_tec_occurrences              |
| wp_6hanxjxbpv_term_relationships           |
| wp_6hanxjxbpv_term_taxonomy                |
| wp_6hanxjxbpv_termmeta                     |
| wp_6hanxjxbpv_terms                        |
| wp_6hanxjxbpv_usermeta                     |
| wp_6hanxjxbpv_users                        |
| wp_6hanxjxbpv_wpaas_activity_log           |
+--------------------------------------------+

As you can see, this output contains tables like wp_6hanxjxbpv_prflxtrflds_field_values (which I verified contained the phone numbers). I guess the prflxtrflds in the name is a vowel-stripped abbreviation for the name of the plugin Profile Extra Fields

This leaves me wondering why $wpdb->tables(‘all’) produces something different from mysql “SHOW TABLES”, and how can I use the methods of $wpdb to produce the same results as mysql “SHOW TABLES”. But those are different questions I will ask. Asked here

Related Posts:

  1. Post meta vs separate database tables
  2. Is it mandatory to use $wpdb->prefix in custom tables
  3. Update Option Stored in Multi-Dimensional Array
  4. Using a database view = evil incarnate?
  5. Writing a plugin that notify my friends of new post that mentions(@) them
  6. WordPress and multithreading
  7. Not sure the best way to save custom plugin data
  8. The ideal place for storing persistent PHP objects
  9. What is the correct way for plugins to create tables with special charset/collation considerations?
  10. Plugin development with unit tests
  11. How is the data stored in the database?
  12. Formatting of curly brackets array from WP database to get more readable output
  13. Actions or filters fired when data is saved in a custom table
  14. Hello dolly type plugin that allows people to add their own
  15. Sample — test — data for large WordPress install
  16. Custom Plugin Database relations
  17. Is there any reason only 1 (my) IP would be added to this table using $wpdn->insert?
  18. How to store data for posts/pages built with drag-n-drop builder?
  19. Database for development
  20. Is there a naming convention for database tables created by a plugin?
  21. Activation hook not creating table
  22. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  23. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  24. Saving data from block editor to the database
  25. Creating table with plugin is not working
  26. dbDelta() Error – Incorrect index name ” for query ALTER TABLE
  27. Get a custom table to an array
  28. Update/insert only a column of database table
  29. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  30. Subscribe to author?
  31. I’m designing a plugin to create database indexes. Suggestions?
  32. WordPress database error for query INSERT INTO
  33. How to connect to AWS RDS external database (not for the core WordPress db)
  34. How should I store a log for my plugin
  35. How to create database table, add data, update and delete using wpdb via plugins?
  36. Using WPDB to output raw XML fails because of wp-blog-header.php
  37. Strange issue saving custom field data for a WooCommerce order
  38. How to perform a heavy and long process in cron jobs?
  39. Form doesnt save to database
  40. Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
  41. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  42. Plugin Development for registered users
  43. Optimising a big WordPress site
  44. wpdb->prepare and mysql UPDATE – how is it done?
  45. dbDelta SQL Query Not Working
  46. dbDelta not installing database
  47. Is it necessary to do validation again when retrieving data from database?
  48. What is the best way to store a few fields?
  49. Plugin: database creation
  50. Adding columns to core tables
  51. How to query custom db table?
  52. Delete data from database using row action
  53. Show dynamic list of products from custom api of another database under same host
  54. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  55. Make Database query only when option is updated
  56. Can we intercept user_login and user_pass from a wp_login_form?
  57. How best to handle database version dependence (from $wp_db_version)
  58. WP: Search and replace in DB programmatically
  59. Using AND and bracket grouping in SQL not working
  60. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  61. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  62. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  63. How do I debug an error that a plugin is causing?
  64. Save temporary registration data
  65. Update plugin settings option_name for big plugin update
  66. $wpdb->update Issue
  67. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  68. Error code when migrate
  69. Why User_login key doesn’t work with wp_update_user()
  70. How to get inserted row IDs for bulk/batch insert with wpdb query?
  71. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  72. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  73. Use admin-post to submit form data to external database
  74. Save in my custom admin page and redirect to the saved object
  75. Relational / Associate tables using native WordPress functionality
  76. WordPress doesn’t create table on plugin activation
  77. Insert Data into Database
  78. Update database record in plugin
  79. How and when would I implement some code which would take data from one part of the Db and put it in another?
  80. pull data from wordpress database
  81. Ajax not working to insert, query and result data
  82. Why Worpdress doesn’t create table in database?
  83. Form and database, plugin development
  84. How to filter get_adjacent_post()?
  85. How to add additional field in a table row after creating a table?
  86. Post data in wp-admin to external database
  87. How can I get a plugin to hook ‘dbdelta_queries’ — a filter used during version update?
  88. Running one-off cron jobs when WP_DISABLE_CRON is true: can I hit /wp-cron.php?
  89. How to create a database table in WordPress using PHP
  90. Leveraging Core Functionality in Icon Upload Plugin [closed]
  91. Can I log the searches that are returning 404 in the DB?
  92. Programmatically creating posts based on external JSON feed (asynchronously)
  93. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]
  94. Making a user platform reachable by a qr code on a pin-back-button [closed]
  95. multiple record insert creating many duplicate records
  96. Custom Plugin Breaks Other Plugin Functions
  97. Custom database table entry edit page
  98. Update Cache on Save Instead of Clearing It?
  99. Images stored from external API not loading
  100. Is there a way to force plugins to use Flyway migrations for database changes?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)