sheeri kritzer wrote:
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What does
describe mysql.func;
Hi Sheeri,
I don't think I was doing anything other than trying to get 5.0
installed on my Win2K development box at home (which is a whole other
story). No dumping etc.
mysql> describe mysql.func;
+-------+------------------------------+------+-----+----------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+----------+-------+
| name | char(64) | NO | PRI | NULL | |
| ret | tinyint(1) | NO | | 0 | |
| dl | char(128) | NO | | NULL | |
| type | enum('function','aggregate') | NO | | function | |
+-------+------------------------------+------+-----+----------+-------+
4 rows in set (0.00 sec)
Does the following work?
describe clientdb.func;
(where 'clientdb' is the name of the client database it's in)
mysql> describe hasbeans.func;
+-------+------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+---------+-------+
| name | char(64) | NO | PRI | NULL | |
| ret | tinyint(1) | NO | | 0 | |
| dl | char(128) | NO | | NULL | |
| type | enum('function','aggregate') | NO | | NULL | |
+-------+------------------------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
mysql> select * from hasbeans.func;
Empty set (0.00 sec)
mysql> select * from mysql.func;
Empty set (0.00 sec)
So they are identical and both empty. I was pretty sure I could delete
the client one, but just wanted to check first.
And yes, it only appears in that one database. Very strange indeed. Oh
well, it will disappear shortly :)
Thanks for the response.
If the former and the latter give you a table description and no
errors, I'd say it's OK to delete the func table in the client db. Is
it in all client dbs or just that one? A mysqldump/import could have
been editing and done wrong....but I haven't done an in-place upgrade,
so I can't say for sure what the upgrade might or might not do and if
there are bugs or not.
-Sheeri
On 5/11/06, Amer Neely <[EMAIL PROTECTED]> wrote:
I've just noticed in one of my databases a table named 'func', which I'm
positive I never created.
It was empty and has 4 columns:
mysql> describe func;
+-------+------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+---------+-------+
| name | char(64) | NO | PRI | NULL | |
| ret | tinyint(1) | NO | | 0 | |
| dl | char(128) | NO | | NULL | |
| type | enum('function','aggregate') | NO | | NULL | |
+-------+------------------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
A search for 'func' in the 5.0 docs reveals there apparently is a system
table in the mysql database called 'func', but I can't find anything
about why it would be created in a client database.
It does appear in my mysql database as well, but no others. Anyone got
an idea where it's coming from? And can I delete it from the client
database?
I suspect this may have something to do with my recent upgrade to 5.0
but I don't see the purpose, especially as it only appears in one of my
client databases.
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
