table not displayed in tree part of HSQL

BubikolRamios's profile image BubikolRamios posted 11 years ago in General Permalink
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's profile image BubikolRamios posted 11 years ago Permalink
checked: information_schema/tables

it is there.
BubikolRamios's profile image BubikolRamios posted 11 years ago Permalink
ignore last thread, ws loking at wrong db.

checked: information_schema/tables

it is notthere.

so it appears to be db problem
BubikolRamios's profile image BubikolRamios posted 11 years ago Permalink
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's profile image ansgar posted 11 years ago Permalink
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's profile image BubikolRamios posted 11 years ago Permalink
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.