Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
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:39DIR . 07/01/2004 11:39DIR .. 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:0320 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:038,820 columns_priv.frm 22/12/2003 21:030 columns_priv.MYD 22/12/2003 21:031,024 columns_priv.MYI 22/12/2003 21:039,178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:033,072 db.MYI 22/12/2003 21:038,665 func.frm 22/12/2003 21:030 func.MYD 22/12/2003 21:031,024 func.MYI ## no help_category keyword relation topic 22/12/2003 21:039,148 host.frm 22/12/2003 21:030 host.MYD 22/12/2003 21:031,024 host.MYI ## no proc.form .MYD .MYI 22/12/2003 21:038,925 tables_priv.frm 22/12/2003 21:030 tables_priv.MYD 22/12/2003 21:031,024 tables_priv.MYI 22/12/2003 21:039,992 user.frm 08/01/2004 04:27 576 user.MYD 08/01/2004 04:542,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\binmysql -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
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 14:40 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi, 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 MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. It is important for us to know what exactly is failing, my guess is that you tried to install 5.0 over existing installation and the whole Grant Tables group it isn't installed, then in this case the solution should be to install in new directory. -- 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]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
Miguel Angel Solórzano MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. Morten Gulbrandsen Interesting, obviously something is missing, anyway 5.0.0.a is present. I could try that, Miguel Angel Solórzano It is important for us to know what exactly is failing, my guess is that you tried to install 5.0 over existing installation and the whole Grant Tables group it isn't installed, then in this case the solution should be to install in new directory. Morten Gulbrandsen This is true, I had another version 4.0.x alpha running, installed in the same directory. But I removed all of it, except my own sql files. some traces of it could make problems, I'd prefer not to format my hard disk in order to get completely rid of mysql. 4 ;-) I used the uninstaller from control panel, which also renamed a my.cnf file. The environment variable I believe is correct. Miguel Angel Solórzano installed, then in this case the solution should be to install in new directory. Morten Gulbrandsen OK, I can do that, and then I can copy the missing stuff back into the correct directory. however I got no warnings or error messages, that files already were present or options which asked me to choose between overwrite or replace. I simply can't see why another installation which is simply a file copying procedure, fails if I somehow uninstall older MySQL versions. Since I renamed the other directory a clash with older installation is impossible, I created a new mysql directory with nothing, before I installed again. ERROR 1146 at line 24: Table 'mysql.proc' doesn't exist the same error again, I did the following, C:\Documents and Settings\Administratornet stop mysql The MySql service is stopping.. The MySql service was stopped successfully. then I renamed the old directory to mysql_old, I did not remove it just in order to compare, I installed again , selected custom and verified that all stuff was checked, then I did C:\Documents and Settings\Administratornet start mysql The MySql service is starting. The MySql service was started successfully. took my file and ran it, I:\mysql\binmysql -u root -vvv testtest.sql -- DROP TABLE IF EXISTS A -- ## Table was nonexistent. Query OK, 0 rows affected, 1 warning (0.06 sec) -- 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 -- ## please why this warning ? can I have more details ? Query OK, 0 rows affected, 1 warning (0.13 sec) -- 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.02 sec) -- ALTER TABLE A ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE -- ERROR 1146 at line 24: Table 'mysql.proc' doesn't exist Bye I:\mysql\data\mysqldir Volume in drive I is Application program files Volume Serial Number is 906C-357F Directory of I:\mysql\data\mysql 08/01/2004 19:01 DIR . 08/01/2004 19:01 DIR .. 22/12/2003 21:038,820 columns_priv.frm 22/12/2003 21:030 columns_priv.MYD 22/12/2003 21:031,024 columns_priv.MYI 22/12/2003 21:039,178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:033,072 db.MYI 22/12/2003 21:038,665 func.frm 22/12/2003 21:030 func.MYD 22/12/2003 21:031,024 func.MYI 22/12/2003 21:039,148 host.frm 22/12/2003 21:030 host.MYD 22/12/2003 21:031,024 host.MYI 22/12/2003 21:038,925 tables_priv.frm 22/12/2003 21:030 tables_priv.MYD 22/12/2003 21:031,024 tables_priv.MYI 22/12/2003 21:039,992 user.frm 22/12/2003 21:03 160 user.MYD 22/12/2003 21:032,048 user.MYI 18 File(s) 64,410 bytes 2 Dir(s) 3,870,883,840 bytes free The same 18 files, nothing could have prevented the missing files to be correctly written. first installation was typical, second installation was custom with all checkboxes, in fact even during the typical installation it was impossible to uncheck two of the options, one of the mandatory options was something with grant tables. It is ok for me to know that this problem is not known under win XP, What about Linux ? It
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 20:02 8/1/2004 +0100, Morten Gulbrandsen wrote: hi, Well I will test that on my win2k server machine is now down running instead Suse 9.0. Anyway you have the option for to download the package without installer, then is just an issue to unzip the files in the right place. You should this option package in our web site in the same place of one you have already downloaded one line below. -- 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]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
Miguel Angel Solórzano Well I will test that on my win2k server machine is now down running instead Suse 9.0. Morten Gulbrandsen Thanks, If I know that it runs satisfactorily under suse, I'm satisfied, I have suse 8.2, but I can go for suse 9.0 If necessary. Miguel Angel Solórzano Anyway you have the option for to download the package without installer, then is just an issue to unzip the files in the right place. You should this option package in our web site in the same place of one you have already downloaded one line below. Morten Gulbrandsen This could be the reason, I saw the package without installer, I'll go for it, I understand the distributions with and without installer are not quite the same, Did you use the win distribution without the installer ? Anyway it is an alpha version and I'd like to test the features I need. Previously the linux version was slightly ahead of the same windows version. So I believe that you primarily target the linux users. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
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), DNOINT 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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\binmysql -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\bindir c:\mysql\data\mysql O volume na unidade C é Disk 1 Partition 1 O número de série do volume é - Pasta de c:\mysql\data\mysql 07/01/2004 11:39DIR . 07/01/2004 11:39DIR .. 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:0320 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), DNOINT 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]