How to install Phoenix on a WAMP server
Posted: Thu Jul 17, 2025 12:15 am
If you are having troubles installing Phoenix on a WAMP server, here are two things to check ...
Starting with Phoenix 1.0.8.x, the developers switched from a MYISAM engine in mySQL to a InnoDB engine. This is a 'behind-the-scenes' change, but may give you problems if your WAMP server is not configured correctly.
If your installation of WAMP uses the MYISAM engine by default (mine did), you can change it several ways ...
1) In your WAMP console, click on 'MySQL'. Click on 'my.ini'. This should open your my.ini file with your default text editor ...
Scroll down to the 'default_storage_engine' entry. Comment out the MYISAM entry (add a semi-colon in front of the line), and un-comment the InnoDB entry (remove the semi-colon in front of the line). Save the file. Now, 'Restart All Services'
-or -
2) In your WAMP console, click on 'MySQL'. Click on 'MySQL Settings'. Now, click on 'Default Storage Engine'. Select 'InnoDB'. All services will restart.
-or-
3) You can edit the sql file in the Phoenix installation. From your store root directory, change to ''install' directory. Open the file 'phoenix.sql' with your favorite text editor (I like Notepad ++). There will be many 'Create Table' entries. At the bottom of each entry, there is a line:
Change this to:
for ALL of the entries. You can use your file editor's "find and replace" function. Review all of your edits for mistakes, and save the file.
-----------------------------------------------------------------
Once you have configured your WAMP server to use the InnoDB engine, there is one more setting you have to check ...
From the WAMP console, click on 'MySQL'. Click on 'MySQL Settings'. If the 'innodb_default_row_format' is not 'dynamic', click on it, and select 'dynamic'. Your services will restart.
-----------------------------------------------------------------
These two settings should enable you to now install and run Phoenix on your WAMP server.
Malcolm
Starting with Phoenix 1.0.8.x, the developers switched from a MYISAM engine in mySQL to a InnoDB engine. This is a 'behind-the-scenes' change, but may give you problems if your WAMP server is not configured correctly.
If your installation of WAMP uses the MYISAM engine by default (mine did), you can change it several ways ...
1) In your WAMP console, click on 'MySQL'. Click on 'my.ini'. This should open your my.ini file with your default text editor ...
Scroll down to the 'default_storage_engine' entry. Comment out the MYISAM entry (add a semi-colon in front of the line), and un-comment the InnoDB entry (remove the semi-colon in front of the line). Save the file. Now, 'Restart All Services'
-or -
2) In your WAMP console, click on 'MySQL'. Click on 'MySQL Settings'. Now, click on 'Default Storage Engine'. Select 'InnoDB'. All services will restart.
-or-
3) You can edit the sql file in the Phoenix installation. From your store root directory, change to ''install' directory. Open the file 'phoenix.sql' with your favorite text editor (I like Notepad ++). There will be many 'Create Table' entries. At the bottom of each entry, there is a line:
Code: Select all
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Code: Select all
ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;-----------------------------------------------------------------
Once you have configured your WAMP server to use the InnoDB engine, there is one more setting you have to check ...
From the WAMP console, click on 'MySQL'. Click on 'MySQL Settings'. If the 'innodb_default_row_format' is not 'dynamic', click on it, and select 'dynamic'. Your services will restart.
-----------------------------------------------------------------
These two settings should enable you to now install and run Phoenix on your WAMP server.
Malcolm