|
Replies:
7
-
Pages:
1
-
Last Post:
Jul 11, 2011 9:33 AM
by: Mauritz
|
|
|
Posts:
3
Registered:
10/11/10
|
|
|
|
Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Oct 11, 2010 3:39 PM
|
|
|
When I look in Object Explorer under a database I have created, I don't see any of the tables listed that I created. No list at all. When I right-click and select refresh....nothing happens. I've tried granting all to the user I'm logged in with, close and re-open Toad for MySQL, rebooted everything, installed the update to TOAD. What am I missing?
thanks
|
|
|
Posts:
3
Registered:
10/13/10
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Oct 13, 2010 2:08 PM
in response to: Icewast
|
|
|
Icewast,
to check whether your tables were really created, select the information_schema 'database' and query the TABLES table. You can add a filter to only view the tables in the database you created by adding a where clause on the table_schema field. If your tables are not listed, they were not created... If they are, then you more than likely have a permission issue with the user you have set up. If you do not have permission to read the information_schema 'database', then you may have to switch to the root user to do so.
Good luck,
Chris
|
|
|
Posts:
3
Registered:
10/11/10
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Oct 14, 2010 7:44 PM
in response to: Icewast
|
|
|
Chris,
Thank you for the post. I was thinking it was a permission issue, but I am logged in under the root user and it still isn't showing the tables. I did check that the tables had indeed been created. I'm good there. I can see the tables logged in under root using the MySQL Admin utility that came with the server install. It's just not showing up in TOAD for MySQL. I'll try messing around with the persmission a bit more.
Any other suggestions?
Thanks!
|
|
|
Posts:
3
Registered:
10/11/10
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Oct 20, 2010 6:41 PM
in response to: Icewast
|
|
|
I have double checked the user privileges and it has full access to everything. Still the tables won't show up in the Object Explorer. Refresh does nothing. I switched the the 'root' user and still the same problem. Not sure where to go from here. any other suggestions would be great.
Thanks
|
|
|
Posts:
1
Registered:
7/10/11
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Jul 10, 2011 1:32 PM
in response to: Icewast
|
|
|
Im almost embarrassed to ask this question but i have the same problem. I have used toad for oracle and am now using toad for mysql.
In object explorer all i can see is all the tables under system objects in the information_schema. I can query for the tables i added and get results but i cant seem the easily or view the data in them via the object explorer.
All i want to do is to look into the tables i have created so where are they located please?
Thanks
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Jul 10, 2011 2:08 PM
in response to: dkennedy1001
|
|
|
To refresh a list just press F5 and the list you are currently looking at will be refreshed. You can also throw away all the cached data with Shift-F5.
|
|
|
Posts:
40
Registered:
1/27/11
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Jul 11, 2011 8:40 AM
in response to: Mauritz
|
|
|
True, hit F5, but Toad could be a lil more proactive and refresh itself when tables are made, stuff like that.
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Toad for MySQL Object Explorer - tables won't refresh under a database name
Posted:
Jul 11, 2011 9:33 AM
in response to: Scott M. Sanders
|
|
|
Assuming you use Toad to create objects it will refresh itself (If it doesn't then that is a bug). If you create your objects in the editor it also does refresh itself in some cases, but not all because it is very hard for us to know what exactly you are doing with the SQL you are executing in the editor.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
