title: Receiving and processing a Dictionary<string, List<string>> from Soap using KSoap2
body: <p>I am working on an android application which calls a soap function and returns a <code>Diction&lt;string, List&lt;string&gt;&gt;</code>. </p>
  
  <p>The response looks like the below:</p>
  
  <pre><code>&lt;s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"&gt;
     &lt;s:Body&gt;
        &lt;retrieveDatabasesResponse xmlns="http://tempuri.org/"&gt;
           &lt;retrieveDatabasesResult xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;information_schema&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;CHARACTER_SETS&lt;/a:string&gt;
                    &lt;a:string&gt;COLLATIONS&lt;/a:string&gt;
                    &lt;a:string&gt;COLLATION_CHARACTER_SET_APPLICABILITY&lt;/a:string&gt;
                    &lt;a:string&gt;COLUMNS&lt;/a:string&gt;
                    &lt;a:string&gt;COLUMN_PRIVILEGES&lt;/a:string&gt;
                    &lt;a:string&gt;ENGINES&lt;/a:string&gt;
                    &lt;a:string&gt;EVENTS&lt;/a:string&gt;
                    &lt;a:string&gt;FILES&lt;/a:string&gt;
                    &lt;a:string&gt;GLOBAL_STATUS&lt;/a:string&gt;
                    &lt;a:string&gt;GLOBAL_VARIABLES&lt;/a:string&gt;
                    &lt;a:string&gt;KEY_COLUMN_USAGE&lt;/a:string&gt;
                    &lt;a:string&gt;PARAMETERS&lt;/a:string&gt;
                    &lt;a:string&gt;PARTITIONS&lt;/a:string&gt;
                    &lt;a:string&gt;PLUGINS&lt;/a:string&gt;
                    &lt;a:string&gt;PROCESSLIST&lt;/a:string&gt;
                    &lt;a:string&gt;PROFILING&lt;/a:string&gt;
                    &lt;a:string&gt;REFERENTIAL_CONSTRAINTS&lt;/a:string&gt;
                    &lt;a:string&gt;ROUTINES&lt;/a:string&gt;
                    &lt;a:string&gt;SCHEMATA&lt;/a:string&gt;
                    &lt;a:string&gt;SCHEMA_PRIVILEGES&lt;/a:string&gt;
                    &lt;a:string&gt;SESSION_STATUS&lt;/a:string&gt;
                    &lt;a:string&gt;SESSION_VARIABLES&lt;/a:string&gt;
                    &lt;a:string&gt;STATISTICS&lt;/a:string&gt;
                    &lt;a:string&gt;TABLES&lt;/a:string&gt;
                    &lt;a:string&gt;TABLESPACES&lt;/a:string&gt;
                    &lt;a:string&gt;TABLE_CONSTRAINTS&lt;/a:string&gt;
                    &lt;a:string&gt;TABLE_PRIVILEGES&lt;/a:string&gt;
                    &lt;a:string&gt;TRIGGERS&lt;/a:string&gt;
                    &lt;a:string&gt;USER_PRIVILEGES&lt;/a:string&gt;
                    &lt;a:string&gt;VIEWS&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_BUFFER_PAGE&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_TRX&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_BUFFER_POOL_STATS&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_LOCK_WAITS&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_CMPMEM&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_CMP&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_LOCKS&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_CMPMEM_RESET&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_CMP_RESET&lt;/a:string&gt;
                    &lt;a:string&gt;INNODB_BUFFER_PAGE_LRU&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;boardies_password_manager&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;categories&lt;/a:string&gt;
                    &lt;a:string&gt;passwords&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;bugs&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;comments&lt;/a:string&gt;
                    &lt;a:string&gt;logfile_history&lt;/a:string&gt;
                    &lt;a:string&gt;platforms&lt;/a:string&gt;
                    &lt;a:string&gt;privileges&lt;/a:string&gt;
                    &lt;a:string&gt;reports&lt;/a:string&gt;
                    &lt;a:string&gt;requested_features&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;short_bulletins&lt;/a:string&gt;
                    &lt;a:string&gt;software&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;versions&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;bugs_demo&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;comments&lt;/a:string&gt;
                    &lt;a:string&gt;logfile_history&lt;/a:string&gt;
                    &lt;a:string&gt;platforms&lt;/a:string&gt;
                    &lt;a:string&gt;privileges&lt;/a:string&gt;
                    &lt;a:string&gt;reports&lt;/a:string&gt;
                    &lt;a:string&gt;requested_features&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;software&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;versions&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;bugs_old&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;alarms_archive&lt;/a:string&gt;
                    &lt;a:string&gt;comments&lt;/a:string&gt;
                    &lt;a:string&gt;discussions&lt;/a:string&gt;
                    &lt;a:string&gt;message_content&lt;/a:string&gt;
                    &lt;a:string&gt;message_details&lt;/a:string&gt;
                    &lt;a:string&gt;platforms&lt;/a:string&gt;
                    &lt;a:string&gt;reports&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;software&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;versions&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;critimon&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;administrators&lt;/a:string&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;android_devices&lt;/a:string&gt;
                    &lt;a:string&gt;app_using_api_version&lt;/a:string&gt;
                    &lt;a:string&gt;available_sdks&lt;/a:string&gt;
                    &lt;a:string&gt;config_groups&lt;/a:string&gt;
                    &lt;a:string&gt;config_items&lt;/a:string&gt;
                    &lt;a:string&gt;config_values&lt;/a:string&gt;
                    &lt;a:string&gt;crash_details&lt;/a:string&gt;
                    &lt;a:string&gt;customer_queries&lt;/a:string&gt;
                    &lt;a:string&gt;development_devices&lt;/a:string&gt;
                    &lt;a:string&gt;generated_monthly_reports&lt;/a:string&gt;
                    &lt;a:string&gt;registered_apps&lt;/a:string&gt;
                    &lt;a:string&gt;sdk_versions&lt;/a:string&gt;
                    &lt;a:string&gt;user_config_groups&lt;/a:string&gt;
                    &lt;a:string&gt;user_config_items_18&lt;/a:string&gt;
                    &lt;a:string&gt;user_config_values&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;windows_devices&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;email&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;alarms_archive&lt;/a:string&gt;
                    &lt;a:string&gt;attachments&lt;/a:string&gt;
                    &lt;a:string&gt;config_groups&lt;/a:string&gt;
                    &lt;a:string&gt;config_items&lt;/a:string&gt;
                    &lt;a:string&gt;config_values&lt;/a:string&gt;
                    &lt;a:string&gt;queue&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_auth_users&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_details&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_record&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;email_something&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;attachments&lt;/a:string&gt;
                    &lt;a:string&gt;authenticated_users&lt;/a:string&gt;
                    &lt;a:string&gt;auto_replies&lt;/a:string&gt;
                    &lt;a:string&gt;blacklist&lt;/a:string&gt;
                    &lt;a:string&gt;emailqueue&lt;/a:string&gt;
                    &lt;a:string&gt;logfile_history&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_details&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_record&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;whitelist&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;email_test&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;attachments&lt;/a:string&gt;
                    &lt;a:string&gt;authenticated_users&lt;/a:string&gt;
                    &lt;a:string&gt;auto_replies&lt;/a:string&gt;
                    &lt;a:string&gt;blacklist&lt;/a:string&gt;
                    &lt;a:string&gt;emailqueue&lt;/a:string&gt;
                    &lt;a:string&gt;logfile_history&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_details&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_record&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;whitelist&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;email_user&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;emailserver&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;attachments&lt;/a:string&gt;
                    &lt;a:string&gt;authenticated_users&lt;/a:string&gt;
                    &lt;a:string&gt;auto_replies&lt;/a:string&gt;
                    &lt;a:string&gt;blacklist&lt;/a:string&gt;
                    &lt;a:string&gt;emailqueue&lt;/a:string&gt;
                    &lt;a:string&gt;logfile_history&lt;/a:string&gt;
                    &lt;a:string&gt;settings&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_details&lt;/a:string&gt;
                    &lt;a:string&gt;smtp_debug_record&lt;/a:string&gt;
                    &lt;a:string&gt;users&lt;/a:string&gt;
                    &lt;a:string&gt;whitelist&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;mysql&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;columns_priv&lt;/a:string&gt;
                    &lt;a:string&gt;db&lt;/a:string&gt;
                    &lt;a:string&gt;event&lt;/a:string&gt;
                    &lt;a:string&gt;func&lt;/a:string&gt;
                    &lt;a:string&gt;general_log&lt;/a:string&gt;
                    &lt;a:string&gt;help_category&lt;/a:string&gt;
                    &lt;a:string&gt;help_keyword&lt;/a:string&gt;
                    &lt;a:string&gt;help_relation&lt;/a:string&gt;
                    &lt;a:string&gt;help_topic&lt;/a:string&gt;
                    &lt;a:string&gt;host&lt;/a:string&gt;
                    &lt;a:string&gt;ndb_binlog_index&lt;/a:string&gt;
                    &lt;a:string&gt;plugin&lt;/a:string&gt;
                    &lt;a:string&gt;proc&lt;/a:string&gt;
                    &lt;a:string&gt;procs_priv&lt;/a:string&gt;
                    &lt;a:string&gt;proxies_priv&lt;/a:string&gt;
                    &lt;a:string&gt;servers&lt;/a:string&gt;
                    &lt;a:string&gt;slow_log&lt;/a:string&gt;
                    &lt;a:string&gt;tables_priv&lt;/a:string&gt;
                    &lt;a:string&gt;time_zone&lt;/a:string&gt;
                    &lt;a:string&gt;time_zone_leap_second&lt;/a:string&gt;
                    &lt;a:string&gt;time_zone_name&lt;/a:string&gt;
                    &lt;a:string&gt;time_zone_transition&lt;/a:string&gt;
                    &lt;a:string&gt;time_zone_transition_type&lt;/a:string&gt;
                    &lt;a:string&gt;user&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;mysql_server_manager&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;alarms&lt;/a:string&gt;
                    &lt;a:string&gt;config_groups&lt;/a:string&gt;
                    &lt;a:string&gt;config_items&lt;/a:string&gt;
                    &lt;a:string&gt;config_values&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;performance_schema&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;cond_instances&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_current&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_history&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_history_long&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_summary_by_instance&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_summary_by_thread_by_event_name&lt;/a:string&gt;
                    &lt;a:string&gt;events_waits_summary_global_by_event_name&lt;/a:string&gt;
                    &lt;a:string&gt;file_instances&lt;/a:string&gt;
                    &lt;a:string&gt;file_summary_by_event_name&lt;/a:string&gt;
                    &lt;a:string&gt;file_summary_by_instance&lt;/a:string&gt;
                    &lt;a:string&gt;mutex_instances&lt;/a:string&gt;
                    &lt;a:string&gt;performance_timers&lt;/a:string&gt;
                    &lt;a:string&gt;rwlock_instances&lt;/a:string&gt;
                    &lt;a:string&gt;setup_consumers&lt;/a:string&gt;
                    &lt;a:string&gt;setup_instruments&lt;/a:string&gt;
                    &lt;a:string&gt;setup_timers&lt;/a:string&gt;
                    &lt;a:string&gt;threads&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;software_audit_dev&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;fault_notes&lt;/a:string&gt;
                    &lt;a:string&gt;faults&lt;/a:string&gt;
                    &lt;a:string&gt;notes&lt;/a:string&gt;
                    &lt;a:string&gt;software&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
              &lt;a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
                 &lt;a:Key&gt;test&lt;/a:Key&gt;
                 &lt;a:Value&gt;
                    &lt;a:string&gt;fault_notes&lt;/a:string&gt;
                    &lt;a:string&gt;file_history&lt;/a:string&gt;
                    &lt;a:string&gt;my_table&lt;/a:string&gt;
                    &lt;a:string&gt;stored_connections&lt;/a:string&gt;
                 &lt;/a:Value&gt;
              &lt;/a:KeyValueOfstringArrayOfstringty7Ep6D1&gt;
           &lt;/retrieveDatabasesResult&gt;
        &lt;/retrieveDatabasesResponse&gt;
     &lt;/s:Body&gt;
  &lt;/s:Envelope&gt;
  </code></pre>
  
  <p>I am trying to get the count of the elemenets within the  so I can then loop through to get the list but what I've tried doesn't seem to work. </p>
  
  <p>Below is the code I am using</p>
  
  <pre><code>private void processRetrievedDatabase(SoapObject soapResult)
      {
          int i = 0;
          int j = 0;
          SoapObject rootArray = ((SoapObject)soapResult.getProperty(0));
          SoapObject dbArray = ((SoapObject)rootArray.getProperty(0));
          int dbCount = dbArray.getPropertyCount();
          ArrayList&lt;String&gt; databases = new ArrayList&lt;String&gt;();
          while (i &lt; dbCount)
          {
              if (i % 2 == 0)
              {
                  databases.add(dbArray.getPropertyAsString(i));
                  Log.d(TAG, dbArray.getPropertyAsString(i));
              }
              else
              {
                  SoapObject tablesArray = ((SoapObject)dbArray.getProperty(i));
                  int tableCount = tablesArray.getPropertyCount();
                  while (j &lt; tableCount)
                  {
                      Log.d(TAG, tablesArray.getPropertyAsString(j));
                      j++;
                  }
              }
              i++;
          }
  </code></pre>
  
  <p>Below is what I am getting in the logcat</p>
  
  <pre><code>12-04 19:52:49.480: D/Soap Manager(6204): anyType{Key=information_schema; Value=anyType{string=CHARACTER_SETS; string=COLLATIONS; string=COLLATION_CHARACTER_SET_APPLICABILITY; string=COLUMNS; string=COLUMN_PRIVILEGES; string=ENGINES; string=EVENTS; string=FILES; string=GLOBAL_STATUS; string=GLOBAL_VARIABLES; string=KEY_COLUMN_USAGE; string=PARAMETERS; string=PARTITIONS; string=PLUGINS; string=PROCESSLIST; string=PROFILING; string=REFERENTIAL_CONSTRAINTS; string=ROUTINES; string=SCHEMATA; string=SCHEMA_PRIVILEGES; string=SESSION_STATUS; string=SESSION_VARIABLES; string=STATISTICS; string=TABLES; string=TABLESPACES; string=TABLE_CONSTRAINTS; string=TABLE_PRIVILEGES; string=TRIGGERS; string=USER_PRIVILEGES; string=VIEWS; string=INNODB_BUFFER_PAGE; string=INNODB_TRX; string=INNODB_BUFFER_POOL_STATS; string=INNODB_LOCK_WAITS; string=INNODB_CMPMEM; string=INNODB_CMP; string=INNODB_LOCKS; string=INNODB_CMPMEM_RESET; string=INNODB_CMP_RESET; string=INNODB_BUFFER_PAGE_LRU; }; }
  12-04 19:53:01.896: D/Soap Manager(6204): anyType{Key=information_schema; Value=anyType{string=CHARACTER_SETS; string=COLLATIONS; string=COLLATION_CHARACTER_SET_APPLICABILITY; string=COLUMNS; string=COLUMN_PRIVILEGES; string=ENGINES; string=EVENTS; string=FILES; string=GLOBAL_STATUS; string=GLOBAL_VARIABLES; string=KEY_COLUMN_USAGE; string=PARAMETERS; string=PARTITIONS; string=PLUGINS; string=PROCESSLIST; string=PROFILING; string=REFERENTIAL_CONSTRAINTS; string=ROUTINES; string=SCHEMATA; string=SCHEMA_PRIVILEGES; string=SESSION_STATUS; string=SESSION_VARIABLES; string=STATISTICS; string=TABLES; string=TABLESPACES; string=TABLE_CONSTRAINTS; string=TABLE_PRIVILEGES; string=TRIGGERS; string=USER_PRIVILEGES; string=VIEWS; string=INNODB_BUFFER_PAGE; string=INNODB_TRX; string=INNODB_BUFFER_POOL_STATS; string=INNODB_LOCK_WAITS; string=INNODB_CMPMEM; string=INNODB_CMP; string=INNODB_LOCKS; string=INNODB_CMPMEM_RESET; string=INNODB_CMP_RESET; string=INNODB_BUFFER_PAGE_LRU; }; }
  </code></pre>
  
  <p>I have it almost there but it should be printing out the database followed by all tables within log cat and repeating but for some reason it only prints the first database and its tables. </p>
  
  <p>So in my example above, it should print</p>
  
  <pre><code>information_schema
  CHARACTER_SETS
  COLLATIONS
  COLLATION_CHARACTER_SET_APPLICABILITY
  etc
  etc
  boardies_password_manager
  alarms
  categories
  passwords
  etc
  etc
  </code></pre>
  
  <p>But i am only  getting information_schema and its tables not the rest of the databases</p>
  
  <p>Thanks for any help you can provide. </p>