Jump to content
The Uniform Server Community

Inno Database support in Coral 8.0


Yoni
 Share

Recommended Posts

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)

<p class="bbc_center"><span style="font-size:12px;"><strong>Yoni</strong></span></p>

Link to comment
Share on other sites

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.

<p class="bbc_center"><span style="font-size:12px;"><strong>Yoni</strong></span></p>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...