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 <trudge@stripped> 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: trudge@stripped
>> 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: trudge@stripped
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"
