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....
[RESOLVED] How to apply InnoDB under PHP/MYSQL
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
My table engine is MyISAM and InnoDB is not supported by xampp,how could add it on?
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
I've used InnoDB tables a number of times within an XAMPP installation. What makes you say that it's not supported in yours?
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 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
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.
No.I am using latest version of XAMPP,XAMPP1.6.3a which come along with MySQL 5.0.45.
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.)
Problem resolved.Thanks for that info...
Problem resolved.Thanks for that info...