new emerge of mysql whit innodb does not show innodb

[TUX2k]

I emerge -C mysql and added inndb to my usses variable.

After emerging mysql it strated oke but in MySQL system variables
have_innodb is disabled.
How do I turn it on.

[rac]

I emerge -C mysql and added inndb to my usses variable.

If that's not a typo, "innodb" is missing an 'o'.

[TUX2k]

Sorry thats a typo, when emerging I did see the option --with-innodb pass.
But when I start mysql and show MySQL system variables via phpMyAdmin.
The option have_innodb is disabled

Do I have to turn It on some where alse.

I looked on the MySQL site there It says that you have to ad the option

Code: Select all

 [mysqld]
innodb_data_file_path=ibdata:30M

So I did but still no innodb I mysql.

[BigmanJo]

Sorry thats a typo, when emerging I did see the option --with-innodb pass.
But when I start mysql and show MySQL system variables via phpMyAdmin.
The option have_innodb is disabled

Do I have to turn It on some where alse.

I looked on the MySQL site there It says that you have to ad the option

Code: Select all

 [mysqld]
innodb_data_file_path=ibdata:30M

So I did but still no innodb I mysql.

Maybe you forget to turn off the 'skip-innodb'option in the my.cnf file;
default installed at /etc/mysql/

Good Luck!

[bps7j]

I've had this instance of MySQL running for a long time with no problems, but upgrading last night broke InnoDB for me as well. I searched around the forums and found that there is (used to be?) an innodb USE variable. I did find it in /usr/portage/profiles/use.desc but it seems to actually be removed:

Code: Select all

tigger ~ # emerge -pv mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] dev-db/mysql-5.0.22  USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -srvdir -static" 0 kB

See, it's not even in that list. Nevertheless I added it to package.use and rebuilt. Here is some of the output:

Code: Select all

 * You might want to run:
 * "emerge --config =dev-db/mysql-5.0.22"
 * if this is a new install.
 * 
 * InnoDB is *not* optional as of MySQL-4.0.24, at the request of upstream.

OK, looks good.

Code: Select all

tigger ~ # /etc/init.d/mysql restart
 * Re-caching dependency info (mtimes differ)...
 * Stopping mysql ...
 * Stopping mysqld (0)                                                    [ ok ]
 * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 *  ...
 * Starting mysql (/etc/mysql/my.cnf)                                     [ ok ]
tigger ~ # 

Great. But, connecting via the command-line client:

Code: Select all

mysql> show variables like 'have_innodb';
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_innodb   | DISABLED | 
+---------------+----------+
1 row in set (0.00 sec)

mysql> show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined

skip-innodb is NOT defined:

Code: Select all

tigger ~ # grep skip /etc/mysql/my.cnf 
skip-locking
# skip-networking
# skip-innodb

(Notice, /etc/mysql/my.cnf is the file named in the output when I start the daemon).

Any ideas?

[bps7j]

By the way I know this is an old thread, but I see nothing but this type of thing everywhere... if this one doesn't get any replies I'll try cross-posting...

[bps7j]

OK, one more thing I thought to do was check the configuration file backups I've made... good thing I do that I wouldn't have thought I was braindead enough to just accept a new configuration file, but apparently I did it without knowing it.

old:

Code: Select all

innodb_data_file_path           = ibdata1:10M:autoextend

new:

Code: Select all

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

That was the problem.