NYCPHP Meetup

[Phil Powell]

Install it.. where? This is on a remote server that is approximately 5000
miles away!  And I don't even have telnet, much less SSH access.

Phil
----- Original Message ----- 
From: "Nasir Zubair" <lists at ny-tech.net>
To: "'NYPHP Talk'" <talk at lists.nyphp.org>
Sent: Wednesday, September 10, 2003 3:47 AM
Subject: RE: [nycphp-talk] can't create foreign key constraints in
schema -HELP!


> Latest one is 2.5.3. See if using that gives you the option. Of course
> you'll have to install it first ;) http://www.phpmyadmin.net/
>
>
> - Nasir
>
> -----Original Message-----
> From: Phil Powell [mailto:soazine at erols.com]
> Sent: Wednesday, September 10, 2003 3:28 AM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] can't create foreign key constraints in schema
> -HELP!
>
>
> 2.3.3 is what they're running.  Don't know if that version has any option
> for InnoDB
>
> Phil
> ----- Original Message ----- 
> From: "Nasir Zubair" <lists at ny-tech.net>
> To: "'NYPHP Talk'" <talk at lists.nyphp.org>
> Sent: Wednesday, September 10, 2003 3:25 AM
> Subject: RE: [nycphp-talk] can't create foreign key constraints in schema
> -HELP!
>
>
> > In that case you'll have to do it manually, using the following query:
> >
> > ALTER TABLE [table name] TYPE = INNODB;
> >
> > What version of PMA you are running? I have 2.4.0 and it show all
> supported
> > types, including InnoDB. Perhaps your mysql is running with
> "--skip-innodb"
> > switch.
> >
> >
> > -----Original Message-----
> > From: Phil Powell [mailto:soazine at erols.com]
> > Sent: Wednesday, September 10, 2003 3:09 AM
> > To: NYPHP Talk
> > Subject: Re: [nycphp-talk] can't create foreign key constraints in
> > schema -HELP!
> >
> >
> > Let me preface it by saying I've done Oracle for almost 5 years...
> > this is brand new to me!!!
> >
> > I checked using phpMySQLAdmin and InnoDB isn't given as a table type
> option
> > (only ISAM, Berkeley DB, Heap, myISAM and one other one I don't
> remember)..
> >
> > You see, with Oracle, SQL Server and even Access, I've never had to
> specify
> > table type because I would always get - I guess - InnoDB and so
> > foreign
> key
> > constraints were a normal part of table schema design..
> >
> > Phil
> > ----- Original Message -----
> > From: "Nasir Zubair" <lists at ny-tech.net>
> > To: "'NYPHP Talk'" <talk at lists.nyphp.org>
> > Sent: Wednesday, September 10, 2003 3:05 AM
> > Subject: RE: [nycphp-talk] can't create foreign key constraints in schema
> > -HELP!
> >
> >
> > > http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html states "In
> > > MySQL Server 3.23.44 and up, InnoDB tables support checking of
> > > foreign key constraints, including CASCADE, ON DELETE, and ON
> > > UPDATE."
> > >
> > > Looking at the schema you gave, you are not creating "innoDB"
> > > tables.
> > >
> > > For example, you will need to change the first table definition from
> > > this:
> > >
> > > create table if not exists nnet_produkt_varegruppe (
> > > nnet_produkt_varegruppe_id int not null auto_increment, primary
> > > key(nnet_produkt_varegruppe_id),
> > >       nnet_produkt_varegruppe_navn varchar(255) not null
> > > );
> > >
> > > To this:
> > >
> > > create table if not exists nnet_produkt_varegruppe (
> > > nnet_produkt_varegruppe_id int not null auto_increment, primary
> > > key(nnet_produkt_varegruppe_id),
> > >       nnet_produkt_varegruppe_navn varchar(255) not null
> > > )TYPE=INNODB;
> > >
> > > When you leave off the "TYPE" in your table definition, mySQL
> > > assumes it
> > to
> > > be "TYPE=MYISAM", which doesn't support foreign keys.
> > >
> > > More on table types: http://www.mysql.com/doc/en/Table_types.html
> > >
> > > Hope it helps :D
> > >
> > > - Nasir
> > >
> > > -----Original Message-----
> > > From: Phil Powell [mailto:soazine at erols.com]
> > > Sent: Wednesday, September 10, 2003 2:58 AM
> > > To: NYPHP Talk
> > > Subject: Re: [nycphp-talk] can't create foreign key constraints in
> > > schema -HELP!
> > >
> > >
> > > You completely lost me. :(
> > >
> > > Phil
> > >
> > > _______________________________________________
> > > talk mailing list
> > > talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
> >
> > _______________________________________________
> > talk mailing list
> > talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
> >
> >
> > _______________________________________________
> > talk mailing list
> > talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
>
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk