engine
Posted by: nadra (165.16.109.---)
Date: July 25, 2018 02:52PM

hello
I install logicaldoc software and it need mysql with default engine innodb but i installed in wamp with myisam
how can I change it to innodb
because i changed the tables from myisam to innodb but wheb i create arabic folder first appeare and afer i refresh database it returns to ????
can you help me

Options: ReplyQuote
Re: engine
Posted by: RiggsFolly (Moderator)
Date: July 25, 2018 04:09PM

Hi,

To make INNODB the default storage engine edit `my.ini` using the wampmanager menus

Look for the line

default-storage-engine=MYISAM

and change it to

;default-storage-engine=MYISAM

This comments out this line and allows the MySQL default which is INNODB

As to the Arabic characters, you need to make sure that your tables are correctly defined to have the required multi byte character set defined. I suggest you look this up in the MySQL Manual. There is a link in my signature, and one on the wampmanager menus

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

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 MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: engine
Posted by: Otomatic (Moderator)
Date: July 25, 2018 04:34PM

Hi

Setting MyISAM as the default engine does not prevent you from creating InnoDB databases or tables.

Software that relies on default options is bad software.

The engine (ENGINE) must always be specified when creating the table.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.6 32 bit - Apache 2.4.37 - PHP 7.3.0/7.2.13/7.1.25/7.0.33/5.6.39 - MySQL 5.7.23 - MariaDB 10.3.11
Wampserver 3.1.6 64 bit - Apache 2.4.37 - PHP 7.3.0/7.2.13/7.1.25/7.0.33/5.6.39 - MySQL 5.7.23 - MariaDB 10.3.11
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.