<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\Administrator>net 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\Administrator>net start mysql
The MySql service is starting.
The MySql service was started successfully.
took my file and ran it,
I:\mysql\bin>mysql -u root -vvv test < test.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\mysql>dir
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: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 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 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
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 believe it must be a misunderstanding,
under my win2k. the files obviously missing, another installation can't
remedy that.
before I try again with windows I'd like to get some feedback about
debian Linux,
can this be compiled without warning or malfunction ?
==============
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 # here is the buggy code
ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN)
ON DELETE SET NULL
ON UPDATE CASCADE;
===================
Yours Sincerely
Morten Gulbrandsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
