472,805 Members | 1,199 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

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
null.

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 1473
Hi,

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
in-between).

Markus
Dec 25 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
3
by: Elias Farah | last post by:
Dear Access Peers, I am having a problem over a network, where the Database takes 5-Mins to load instead of the normal 5 seconds. It has only started to do this since I split the frontend &...
3
by: sea | last post by:
If a runtime installation of Access is created and installed on a client machine that has a full verion of access, will it still be possible to view the tables and queries in design view but not...
1
by: peter.konda | last post by:
Hello! I have been busting my head with a problem, that goes like this: 1. with a first ajax call to the server(apache 2.0 + php), I create a temporary table like this: create temporary table...
5
by: lawpoop | last post by:
Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function. I'm implementing some temporary tables, which I...
12
by: nyathancha | last post by:
Hi, I have a question regarding best practices in database design. In a relational database, is it wise/necessary to sometimes create tables that are not related to other tables through a...
1
by: kodebalagopal | last post by:
how to see what are the tables already existing tables to see what is the syntax
2
by: dvawdrey | last post by:
Can someone help me please with the following code: try { DatabaseMetaData metadata=con.getMetaData(); System.out.println(metadata.getDriverName()); System.out.println("Driver version:...
0
by: kalesik | last post by:
Hi, I have installed DB2 9.5 on AIX, but can't view tables through control center In db2diag.log: 2008-08-13-13.07.04.461000+330 I3728H809 LEVEL: Error PID : 4012 ...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.