Inno Database support in Coral 8.0

[Yoni]

Hi all,

 

I'm trying to find a way to enable and use InnoDB storage instead of MyISAM. Unfortunately I haven't found a way to enable InnoDB in Coral 8.0. I cannot even see InnoDB in phpMyAdmin. I checked my.ini and as far as I'm concerned InnoDB settings are there and they are enabled. Is it there a way to switch to InnoDB storage instead of using MyISAM as my primary db storage?

 

I'm new to UniServer and I wanna thank everyone of you who worked to make this wonderful "on the go" package possible. By the way, I'm using it in a production environment hosted in VMWare with good uptime and few positive feedbacks from end users.

 

Checking Logs and I found that InnoDB is not initializing...

 

111230  4:45:01 InnoDB: The InnoDB memory heap is disabled
111230  4:45:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111230  4:45:01 InnoDB: Compressed tables use zlib 1.2.3
111230  4:45:01 InnoDB: Initializing buffer pool, size = 200.0M
111230  4:45:02 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file D:\UniServer\usr\local\mysql\data\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
111230  4:45:02 [ERROR] Plugin 'InnoDB' init function returned error.
111230  4:45:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111230  4:45:02 [Note] Event Scheduler: Loaded 0 events
111230  4:45:02 [Note] D:\UniServer\usr\local\mysql\bin\mysqld1.exe: ready for connections.
Version: '5.5.18'  socket: ''  port: 3306  MySQL Community Server (GPL)

[Yoni]

I solved the issue by shutting down the MySQL service and deleting the ib_logfile0 and ib_logfile1. These files are recreated after MySQL is launched next time and since my InnoDB is enabled in my.ini the InnoDB db storage is now loading and showing up in phpMyAdmin.

 

Time to convert a couple of tables from MyISAM to InnoDB now.

 

Good luck everyone.