WampServer

By creating database wampserver 3.0 64 bit, with MySQL 5.7.9, creates the database for MyISAM. and this does not help me.

Anyone know what parameters change in mysql, so that the engine and tables are created for innodb.
Or rather that configuration change?

From already thank you.

lrebolledoch

Hi,

The table type is an option of the "Create Table" syntax.

See "table_option:` in the documentation [dev.mysql.com]

Or there is a simple field called "Storage Engine" on the phpMyAdmin page of the "New Table" screen.

Dont forget to also learn how to backup and restore an INNODB database [dev.mysql.com]

See my signature block for links to the Documentation for MYSQL / Apache / PHP / phpMyAdmin

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 05/16/2016 10:37AM by RiggsFolly.

Not create a table, I need to change the storage engine, MyISAM to InnoDB, but aid, are not clear on how.

Maybe you should consider another hobbie!

ALTER TABLE t1 ENGINE = InnoDB;

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-