I'm confused. According to your note and to a passage I found in the manual, InnoDB support is installed in all 4.0.x versions of MySQL, which should obviously include my 4.0.11 install. Yet SHOW_VARIABLES LIKE 'have_innodb' returned NO. Why? It would appear that I need to do something besides installing a 4.0.x version of MySQL but I can't tell what that is from the manual. I found one section that said installing MySQL-Max-VERSION.i386.rpm will give me "additional capabilities" - without specifying what those capabilities were in any way. Do I need this RPM to get InnoDB support?
By the way, I'm willing to install a newer version of MySQL if that will help. However, that raises some additional questions. I found the Upgrading/Downgrading section of the manual but it's pretty vague. For example it doesn't explicity say whether I need to uninstall 4.0.11 before installing the newer version. I suspect from the wording that I don't need to uninstall first but I'd feel a lot happier is someone could confirm that. Also, the manual says that we are supposed to take backups of our databases before upgrading but the Database Backups section describes several different ways to do backups, each of which seems to be different. Which one should I use: a regular backup or an SQL level backup? Should I use SELECT INTO OUTFILE? BACKUP TABLE? mysqldump? mysqlhotcopy? What are the pros and cons of each? Do I need to do LOCK TABLES and FLUSH TABLES for each of these approaches? If yes, what is the right sequence: do I need to LOCK TABLES and FLUSH TABLES first, then do the backup? Or do I LOCK TABLES, backup, then FLUSH TABLES? The manual leaves a lot to the imagination and I've got a good imagination so I need some clarification ;-) Rhino ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 16, 2004 6:18 AM Subject: Re: Newbie Question > Please, reply to the mailing list, not to me directly. > > Date: Sat, 14 Feb 2004 09:11:14 -0500 > From: Rhino <[EMAIL PROTECTED]> > To: Egor Egorov <[EMAIL PROTECTED]> > Subject: Re: Newbie Question > > > Thanks Egor! I ran the query you suggested and it said 'NO' so the server > > was apparently configured without InnoDB support. > > > > What do I need to do to activate the InnoDB support? Is it just a matter of > >configuring a few settings or do I need to re-install MySQL? > > You can download and install official 4.0.x binary distribution: > http://www.mysql.com/downloads/mysql-4.0.html > > All official 4.0.x binaries include InnoDB storage engine. 4.0.11 is an outdated version, so upgrade is recommended in any case. > > > ----- Original Message ----- > From: "Egor Egorov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, February 14, 2004 4:04 AM > Subject: Re: Newbie Question > > > > "Rhino" <[EMAIL PROTECTED]> wrote: > > > > I'm new to MySQL but I have extensive experience with DB2 so I'm getting > > > > quite confused about how MySQL is supposed to work. > > > > > > > > I am using MySQL 4.0.11 on a Linux server running RedHat 9.2. I am > > > > trying to create a pair of InnoDB tables that are related to one another > > > > via a foreign key. I created the tables successfully but when I try to > > > > insert a row into the child table that violates the foreign key, MySQL > > > > loads the bad row, even though the foreign key doesn't exist! > > > > > > > > > > [skip] > > > > > > > > > > > I got a very big clue when I ran this command: > > > > show table status from Sample; > > > > > > > > It showed that my two tables were type "MyISAM", *not* "InnoDB". > > > > If my > > > > tables really are "MyISAM", then I'm not surprised that the foreign key > > > > constraint doesn't work since MyISAM doesn't support foreign keys, at > > > > least as I understand the manual. > > > > > > > > However, this doesn't answer the big question: *Why* aren't my tables > > > > InnoDB since I explicitly defined them that way?? > > > > > > > > Can any MySQL veterans clear up this mystery for me? > > > > > > If you try to create table type that is disabled or not compiled-in, MySQL > > > creates MyISAM table type. > > > Execute statement > > > SHOW VARIABLES LIKE "have_innodb"; > > > > > > If you see 'DISABLED' in the output, it means that you run MySQL server > > > with skip-innodb option. > > > If you see 'NO' in the output, it means that MySQL server was configured > > > without InnoDB support. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > 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]