470,604 Members | 2,179 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

odd persistent view in tables ??

I've got some kind of a strange thing going on.
a view, lets call it 'xyxj'
that shows up when I run > show tables

Using MySQL Administrator it shows up as a view, I can drop it, but
it reappears on refresh.

Using the CL, as 'root' I've tried both drop table 'xyxj' and
drop view 'xyxj'
I get errors table/view does not exist.

Under information_schema, I can look at 'tables' and for this
'xyxj' only 'table_name' is defined 'xyxj' All other columns are

This is preventing me from doing backups mysqldump, etc.

Using MySQL beta 5.0.4 Is there any logging / log file that can
tell me whats going on ?

Dec 24 '05 #1
1 1359

is there a corresponding .frm file in the data/[database] directory?

However, 5.0.4-beta is a very old version (current is 5.0.17) - I would
recommand you to update to the current version (there was a lot of change

Dec 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Elias Farah | last post: by
1 post views Thread by peter.konda | last post: by
5 posts views Thread by lawpoop | last post: by
1 post views Thread by kodebalagopal | last post: by
reply views Thread by kalesik | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.