Thank you,
I am comparing the two \mysql\data\mysql directories,
finding that many files are simply missing in my installation.
I had another mysql version previously, which I removed,
I also have a different operating system. win2k
Pasta de c:\mysql\data\mysql
07/01/2004 11:39 <DIR> .
07/01/2004 11:39 <DIR> ..
22/12/2003 21:03 8.820 columns_priv.frm
22/12/2003 21:03 0 columns_priv.MYD
22/12/2003 21:03 1.024 columns_priv.MYI
22/12/2003 21:03 9.178 db.frm
22/12/2003 21:03 306 db.MYD
22/12/2003 21:03 3.072 db.MYI
22/12/2003 21:03 8.665 func.frm
22/12/2003 21:03 0 func.MYD
22/12/2003 21:03 1.024 func.MYI
22/12/2003 21:03 8.700 help_category.frm
22/12/2003 21:03 20 help_category.MYD
22/12/2003 21:03 3.072 help_category.MYI
22/12/2003 21:03 8.612 help_keyword.frm
22/12/2003 21:03 0 help_keyword.MYD
22/12/2003 21:03 1.024 help_keyword.MYI
22/12/2003 21:03 8.630 help_relation.frm
22/12/2003 21:03 0 help_relation.MYD
22/12/2003 21:03 1.024 help_relation.MYI
22/12/2003 21:03 8.770 help_topic.frm
22/12/2003 21:03 0 help_topic.MYD
22/12/2003 21:03 1.024 help_topic.MYI
22/12/2003 21:03 9.148 host.frm
22/12/2003 21:03 0 host.MYD
22/12/2003 21:03 1.024 host.MYI
22/12/2003 21:03 9.470 proc.frm
07/01/2004 13:33 156 proc.MYD
07/01/2004 13:33 2.048 proc.MYI
22/12/2003 21:03 8.925 tables_priv.frm
22/12/2003 21:03 0 tables_priv.MYD
22/12/2003 21:03 1.024 tables_priv.MYI
22/12/2003 21:03 9.992 user.frm
22/12/2003 21:03 160 user.MYD
22/12/2003 21:03 2.048 user.MYI
33 arquivo(s) 116.960 bytes
Here is my \data\mysql\ directory
Directory of I:\mysql\data\mysql
05/01/2004 20:44 <DIR> .
05/01/2004 20:44 <DIR> ..
22/12/2003 21:03 8,820 columns_priv.frm
22/12/2003 21:03 0 columns_priv.MYD
22/12/2003 21:03 1,024 columns_priv.MYI
22/12/2003 21:03 9,178 db.frm
22/12/2003 21:03 306 db.MYD
22/12/2003 21:03 3,072 db.MYI
22/12/2003 21:03 8,665 func.frm
22/12/2003 21:03 0 func.MYD
22/12/2003 21:03 1,024 func.MYI
## no help_category keyword relation topic
22/12/2003 21:03 9,148 host.frm
22/12/2003 21:03 0 host.MYD
22/12/2003 21:03 1,024 host.MYI
## no proc.form .MYD .MYI
22/12/2003 21:03 8,925 tables_priv.frm
22/12/2003 21:03 0 tables_priv.MYD
22/12/2003 21:03 1,024 tables_priv.MYI
22/12/2003 21:03 9,992 user.frm
08/01/2004 04:27 576 user.MYD
08/01/2004 04:54 2,048 user.MYI
18 File(s) 64,826 bytes
2 Dir(s) 3,904,598,016 bytes free
Obviously some files are missing,
what can I do, install again ?
I could unzip the mysql-5.0.0-alpha-win.zip without a problem,
and mysql actually runs, under windows 2000,
Perhaps another version of MySQL 5.0 is required for win 2k ?
Has anyone tried mysql-5.0.0-alpha under win2k ?
Please ?
Yours Sincerely
Morten Gulbrandsen
----- Original Message -----
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: "Morten Gulbrandsen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 6:42 AM
Subject: Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 05:26 8/1/2004 +0100, Morten Gulbrandsen wrote:
Hi,
I wasn't able to repeat:
Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
c:\>cd\mysql\bin
C:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE TABLE A (
-> SSN CHAR(9) NOT NULL,
-> SUPERSSN CHAR(9),
-> DNO INT NOT NULL DEFAULT 1,
-> PRIMARY KEY (SSN),
-> INDEX (SUPERSSN),
-> INDEX (DNO)
-> )TYPE = INNODB;
Query OK, 0 rows affected, 1 warning (0.11 sec)
mysql> DESCRIBE A;
+----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| SSN | char(9) | | PRI | | |
| SUPERSSN | char(9) | YES | MUL | NULL | |
| DNO | int(11) | | MUL | 1 | |
+----------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> ALTER TABLE A
-> ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN)
-> ON DELETE SET NULL
-> ON UPDATE CASCADE;
Query OK, 0 rows affected (0.27 sec)
Records: 0 Duplicates: 0 Warnings: 0
Please verify if your MySQL stuff has all the below files:
C:\mysql\bin>dir c:\mysql\data\mysql
O volume na unidade C é Disk 1 Partition 1
O número de série do volume é 0000-0000
Pasta de c:\mysql\data\mysql
07/01/2004 11:39 <DIR> .
07/01/2004 11:39 <DIR> ..
22/12/2003 21:03 8.820 columns_priv.frm
22/12/2003 21:03 0 columns_priv.MYD
22/12/2003 21:03 1.024 columns_priv.MYI
22/12/2003 21:03 9.178 db.frm
22/12/2003 21:03 306 db.MYD
22/12/2003 21:03 3.072 db.MYI
22/12/2003 21:03 8.665 func.frm
22/12/2003 21:03 0 func.MYD
22/12/2003 21:03 1.024 func.MYI
22/12/2003 21:03 8.700 help_category.frm
22/12/2003 21:03 20 help_category.MYD
22/12/2003 21:03 3.072 help_category.MYI
22/12/2003 21:03 8.612 help_keyword.frm
22/12/2003 21:03 0 help_keyword.MYD
22/12/2003 21:03 1.024 help_keyword.MYI
22/12/2003 21:03 8.630 help_relation.frm
22/12/2003 21:03 0 help_relation.MYD
22/12/2003 21:03 1.024 help_relation.MYI
22/12/2003 21:03 8.770 help_topic.frm
22/12/2003 21:03 0 help_topic.MYD
22/12/2003 21:03 1.024 help_topic.MYI
22/12/2003 21:03 9.148 host.frm
22/12/2003 21:03 0 host.MYD
22/12/2003 21:03 1.024 host.MYI
22/12/2003 21:03 9.470 proc.frm
07/01/2004 13:33 156 proc.MYD
07/01/2004 13:33 2.048 proc.MYI
22/12/2003 21:03 8.925 tables_priv.frm
22/12/2003 21:03 0 tables_priv.MYD
22/12/2003 21:03 1.024 tables_priv.MYI
22/12/2003 21:03 9.992 user.frm
22/12/2003 21:03 160 user.MYD
22/12/2003 21:03 2.048 user.MYI
33 arquivo(s) 116.960 bytes
>MySQL 5.0.0-alpha-max-nt under win2k
>
>a small problem:
>
>If I have a foreign key with reference to the same table,
>I get an error,
>
>ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
>
>what can I do ?
>
>Yours Sincerely
>
>Morten Gulbrandsen
>================================
>
>USE test;
>
>DROP TABLE IF EXISTS A;
>
>CREATE TABLE A
>(
>SSN CHAR(9) NOT NULL,
>SUPERSSN CHAR(9),
>DNO INT NOT NULL DEFAULT 1,
>
>PRIMARY KEY (SSN),
>INDEX (SUPERSSN),
>INDEX (DNO)
>
>)TYPE = INNODB;
>
>DESCRIBE A;
>
>ALTER TABLE A # line 42 here is the buggy code
>ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN)
>ON DELETE SET NULL
>ON UPDATE CASCADE;
>
>#ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
>
>
>mysql> select version();
>+--------------------+
>| version() |
>+--------------------+
>| 5.0.0-alpha-max-nt |
>+--------------------+
>1 row in set (0.00 sec)
>
>
>Microsoft Windows 2000 [Version 5.00.2195]
--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]>
São Paulo - Brazil
----------------------------------------------------------------------------
----
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003
>
>
----------------------------------------------------------------------------
----
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
