distal-attribute
distal-attribute
distal-attribute
distal-attribute

table not displayed in tree part of HSQL

BubikolRamios posted 2 years ago in General
see image:

1. it is not last heidi sql version problem, changed back to one of previous vesions and it is same thing.
2. the table is there coz the query works (as seen on screen shot)
3. on my server the table is visible, on local host not

Any suggestion what to look for to extract the problem ?
BubikolRamios posted 2 years ago
checked: information_schema/tables

it is there.
BubikolRamios posted 2 years ago
ignore last thread, ws loking at wrong db.

checked: information_schema/tables

it is notthere.

so it appears to be db problem
BubikolRamios posted 2 years ago
Note: there are several tables not in information_schema/tables, hence not visible to heidisql tree structure.

The data were transfered from production db to local with heidi sql.
ansgar posted 2 years ago
HeidiSQL retrieves tables with SHOW TABLE STATUS, not via IS.TABLES. But anyway, seems you have something broken on your local server. Is that table probably stored in a different DB? Find out with such a query:

SELECT * FROM `information_schema`.`TABLES` WHERE `TABLE_NAME` IN ('stat_session')

BubikolRamios posted 2 years ago
Not in other db, otherwise the query on upper image would not work. Anyway, I think not heidisql problem.

Please login to leave a reply, or register at first.