[RESOLVED] How to apply InnoDB under PHP/MYSQL

devil_vin

Hi...I had found an application which need InnoDB,I am not sure what is it.However it doesn't support by PHP/MYSQL,I am using xampp as localhost.May somebody help me to work it out?Thanks....

MarkR

InnoDB is a table engine used by MySQL. It is enabled in most builds of MySQL.

Consult your database administrator, or the packagers of your MySQL distribution to see whether it is available (Try "SHOW ENGINES" in the mysql command line too).

Mark

devil_vin

My table engine is MyISAM and InnoDB is not supported by xampp,how could add it on?

MarkR

Contact the distributors of your distribution of mysql to see if they have one which does, or a way to add it.

You don't need to use xampp's MySQL, you could get an official build from MySQL instead (it will still be compatible from a client point of view)

Mark

NogDog

I've used InnoDB tables a number of times within an XAMPP installation. What makes you say that it's not supported in yours?

devil_vin

NogDog wrote:
I've used InnoDB tables a number of times within an XAMPP installation. What makes you say that it's not supported in yours?

When I creating table in XAMPP's phpmyadmin,the options of storage engine I have only consits of MyISAM,MEMORY,BLACKHOLE,ARCHIVED,,FEDERATED,
MRG_MYISAM

devil_vin

NogDog wrote:
I've used InnoDB tables a number of times within an XAMPP installation. What makes you say that it's not supported in yours?

When I creating table in XAMPP's phpmyadmin,the options of storage engine I have only consits of MyISAM,MEMORY,BLACKHOLE,ARCHIVED,,FEDERATED,
MRG_MYISAM

NogDog

What version of MySQL are you running? Per the manual, "InnoDB is included in binary distributions by default as of MySQL 4.0." Hopefully you're not still using MySQL3 (especially since they've now made an end-of-lifecycle announcement for all versions less than 5). If you're using 3.23, see http://dev.mysql.com/doc/refman/4.1/en/innodb-in-mysql-3-23.html, though maybe you'd be better off just getting a current download of XAMPP or WAMP or whatever and get your versions up to date.

devil_vin

No.I am using latest version of XAMPP,XAMPP1.6.3a which come along with MySQL 5.0.45.

NogDog

OK, it looks like the XAMPP installation of phpMyAdmin has InnoDB disabled by default for some unknown reason. See this article for a description of how to enable it. (I probably selected some option during installation to enable it, as I know I never had to do this.)

devil_vin

Problem resolved.Thanks for that info...🙂

devil_vin

Problem resolved.Thanks for that info...🙂