hi,
I am referring "Innodb startup options" and "my.cnf file options" as in
the manual.
Till this I have installed the MyQSL-Max-3.23.47 and mysql-max daemon is
running. I can go to mysql command prompt.
mysql> show variables like "have_innodb";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_innodb | DISABLED |
+---------------+----------+
1 row in set (0.00 sec)
I am wanting to enable have_innodb feature.
I am in trouble because whatever given in the manual to set the
configuration file my.cnf for enabling innodb is not like it is
appearing. I am going to give you more details as in some of the
outputs..so please help me out. I have to configure it very urgently.
1. I have found the files my-xxxx.cnf at /usr/doc/MySQL-3.23.47 ( and at
. I have uncommented the variable
(please, see the file o/p below)
innodb_data_file_path = ibdata1:1000M ( what is ibdata1 ????? do
I need to create this.?? ) innodb_data_home_dir = /var/lib/mysql/
then, I have renamed one of the my-xxxx.cnf file to my.cnf and
copied it to the /etc/ . but if I do this and try to go to mysql
command prompt still I am getting
mysql> show variables like "have_innodb";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_innodb | DISABLED |
+---------------+----------+
1 row in set (0.00 sec)
What does it shows !! still innodb not enabled ? How do I ensure
the innoDB that it has been enabled ? do I need to do more changes
in the my.cnf file ? or I have to place it at more the one directories?
Please, do the needful..?
Thanks and regards,
Chetan Lavti
-----Original Message-----
From: Arjen Lentz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:18 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB help !!
Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
> It seems, you suggesting that after setting changes in the
configuration
> file the "Show variable....." will list out the 'YES' in front of
> 'have_innodb' (in table below). right ??
Indeed.
> The second thing is that, how do I test for the innoDB support ?
In exactly the same way. You can run the above query from your
application too, no prob. For instance:
SHOW VARIABLES LIKE "have_innodb"
If the result set contains at least 1 row and the "Value" (2nd) column
of the result set is "YES", then you know that InnoDB is enabled in the
server.
> specifically whether it is making the my database memory-resident or
> not.
What do you mean?
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer
/_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia
<___/ www.mysql.com
---------------------------------------------------------------------
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
