I fixed the problem below by uninstalling, reinstalling and using the WinMySQLAdmin tool.. It left my.ini as:
[mysqld] basedir=C:/mySql/ datadir=C:/mySql/data innodb_data_file_path=ibdata1:30M:autoextend [WinMySQLAdmin] Server=C:/mySql/bin/mysqld-max-nt.exe innodb_data_home_dir = C:\mySql\ibdata Rob :) > -----Original Message----- > From: Robert Mark Bram [mailto:[EMAIL PROTECTED] > Sent: Sunday, 23 February 2003 1:03 AM > To: Mysql > Subject: RE: mysqld-max but still no referential integrity? > > > Howdy all! > > I have changed my my.ini but my problem remains... details below. > Any further assistance would be greatly appreciated! > > I apolagise to all if it seems I am flooding.. :( > > Rob > :) > :-> > :-} > > ====== my.ini > [mysqld] > basedir=C:/mySql/ > datadir=C:/mySql/data > > [WinMySQLAdmin] > Server=C:/mySql/bin/mysqld-MAX-nt.exe > innodb_data_home_dir = C:\mySql\ibdata > innodb_data_file_path=ibdata1:30M:autoextend > > ====== Creating tables with referential integrity? > > C:\mySql\bin>mysql --local-infile -h localhost -u rob -prob > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 to server version: 3.23.55-max-nt > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > mysql> CREATE DATABASE menagerie; > Query OK, 1 row affected (0.01 sec) > > mysql> USE menagerie; > Database changed > mysql> CREATE TABLE owner ( > -> name VARCHAR(20) NOT NULL, > -> PRIMARY KEY (name) > -> INDEX owner_name_idx (name)) > -> TYPE = InnoDB; > ERROR 1064: You have an error in your SQL syntax near 'INDEX > owner_name_idx > (name)) > TYPE = InnoDB' at line 4 > mysql> CREATE TABLE pet ( > -> name VARCHAR(20) NOT NULL, > -> species VARCHAR(20) NOT NULL, > -> sex CHAR(1) NOT NULL, > -> birth DATE, > -> death DATE, > -> name1 VARCHAR(20) NOT NULL, > -> PRIMARY KEY (name), > -> INDEX owner_name (name1), > -> FOREIGN KEY (name1) REFERENCES owner (name) > -> ON DELETE SET NULL > -> ON UPDATE CASCADE) > -> TYPE = InnoDB; > Query OK, 0 rows affected (0.05 sec) > > mysql> drop database menagerie; > Query OK, 3 rows affected (0.01 sec) > > mysql> CREATE DATABASE menagerie; > Query OK, 1 row affected (0.00 sec) > > mysql> USE menagerie; > Database changed > mysql> CREATE TABLE owner ( > -> name VARCHAR(20) NOT NULL, > -> PRIMARY KEY (name), > -> INDEX owner_name_idx (name)) > -> TYPE = InnoDB; > Query OK, 0 rows affected (0.05 sec) > > mysql> CREATE TABLE pet ( > -> name VARCHAR(20) NOT NULL, > -> species VARCHAR(20) NOT NULL, > -> sex CHAR(1) NOT NULL, > -> birth DATE, > -> death DATE, > -> name1 VARCHAR(20) NOT NULL, > -> PRIMARY KEY (name), > -> INDEX owner_name (name1), > -> FOREIGN KEY (name1) REFERENCES owner (name) > -> ON DELETE SET NULL > -> ON UPDATE CASCADE) > -> TYPE = InnoDB; > Query OK, 0 rows affected (0.06 sec) > > mysql> insert into PET (name,species,sex,birth,death,name1) values > ('Chicko2','Dog','m',2001/11/04,\N,'Robsdf'); > Query OK, 1 row affected (0.01 sec) > > mysql> quit > Bye > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php