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

table not displayed in tree part of HSQL

User, date Message
Written by BubikolRamios
1 year ago
Category: General
327 posts since Thu, 14 Jan 10
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 ?
Written by BubikolRamios
1 year ago
327 posts since Thu, 14 Jan 10
checked: information_schema/tables

it is there.
Written by BubikolRamios
1 year ago
327 posts since Thu, 14 Jan 10
ignore last thread, ws loking at wrong db.

checked: information_schema/tables

it is notthere.

so it appears to be db problem
Written by BubikolRamios
1 year ago
327 posts since Thu, 14 Jan 10
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.
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
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')

Written by BubikolRamios
1 year ago
327 posts since Thu, 14 Jan 10
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.