Joomla! 3 installation freezes at creating database table

mysql installation wampserver freeze joomla3.0
Universe picture Universe · Feb 2, 2014 · Viewed 94.1k times · Source

I am trying to install Joomla! 3.2.1 on my system but the installation freezes half way through. I've downloaded and installed the Wamp Server 2.4 and wanted to locally install Joomla! 3.2.1, but the installation freezes and doesn't finish.

browser screenshot of hanging install

It stops short of finishing the installation during the "creating database tables" task: it just stays on this bit seemingly forever.

Increasing the max execution time in php.ini and restarting the wamp didn't help.

My Wamp 2.4 uses:

  • MySQL 5.6.12
  • php 5.4.16
  • Apache 2.4.4

How can I get the installer to go past this point?

Answer

Universe picture Universe · Feb 2, 2014

This problem occurring most usually at Joomla 3.x. To solve this go to wamp\www\Your joomla folder\installation\sql\mysql and open Joomla.sql file find the term

"ENGINE=InnoDB"

and replace ALL with

"ENGINE=MyIsam"

MyIsam is more supported and compatible with Joomla.

Do also the same with (sample_data.sql) file, if it's quickstart setup.

Related questions

Installing PDO driver on MySQL Linux server

I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and safely save HTML in the database. Well, here are the main problems: I looked at http://php.net/manual/en/…

Read More
Xampp MySQL not starting - "Attempting to start MySQL service..."

I've just installed XAMPP for Windows - should be the newest version (XAMPP Control Panel v3.2.1). Apache is running just fine on port 80 and 443, but MySQL is not starting. When I press the start button, I get this message: Attempting …

Read More
Mac install and open mysql using terminal

I downloaded the mysql dmg file and went through the wizard to run. Done. I have also started mysql server under system preferences. The purpose of me doing this is to work through the exercises of my SQL text book. …

Read More