TRouble with MySQL Control Center.

[Baldorcete]

Ok. I'm an absolute ignorant about databases, and about MySQL in particular, so I don't know were to look to solve this problem. I searched the site of MySQL, without finding any hint (There should be there, but i don't know were to look).

The problem is, in de computer of a friend, with MySQL Control Center we can look at all the tables in the DB nwn, but opening them we see the error

[nwnuser] ERROR 1146: Table 'nwn.1' doesn't exist

But we can see the contents of the tables. Also, trying to edit the contents of the tables (Ex. Delete one record) reports the same error, and we can change nothing.

The table 1 dosn't exists. Create one don't solve anithing. And i cant (don't know how) reproduce the error in my home computer. Any hint about were to look for the problem?

Thanks.

[Manuel]

Error 1146 is a general error that is being returned from the MySQL database to the Control Center:

[Baldorcete]

Thanks, this it exactly the same error my friend is being sufering. And yes, he is using MySQL 5.something Alpha, and has been reprimanded for this.

He is having the same error, with the table .1 non existent, and all the queries from the CC refering to it. But still no solution. I will recomend again switching to MySQL 4.something.

By the way, do you know some alternative to Control Center that works with MySQL 5?

[Papillon]

I'm not sure about version 5, but I'm happily using both MySQL Administrator and MySQL Query Browser on Windows. They're rewritten from the ground up and seem to be worthy successor to the MySQL Control Center.
_________________
Papillon

[Manuel]

If you want to continue to use MySQL Control Center. I'd suggest switching to the latest version of MySQL 4.1. This version has all the subselect functionality and so forth. Very stable.

[Baldorcete]

Ok. Thanks for all the replies. Maybe i can use some time I will be away from my computer to learn some MySQL. Some sugestion for a MySQL for domyes worth his price (In death tree form, i will be almost disconected for a month or two).

Thanks.

[Kormak]

We switch to the latest version of MySQL 4.1 because with 5.1 using both MySQL Administrator and MySQL Query Browser on Windows we cant manually edit tables and change/modify/delete fields.

Now working fine and updating to OBDC2, thanks and good job guys.