Thanks, I'd already seen that, but it doesnt exactly say what the mininum required version of MySQL is.
My issue is that most shared hosting providers (I know I know, I'm being tight ;-)) are still using MySQL versions older than 5.6 which from what I've gathered is the mininum.
I have found a good provider that offers everything I need apart from they are currently on MySQL 5.5.
My question is really, will Umbraco 6 work on MySQL 5.5?
To confirm, after a little playing around Umbraco 6 will work on a MySQL 5.5 server.
to get this to work you need to:
1. Create the database via the usual installation on a MySQL 5.6 instance.
2. Export the database as a script
3. Edit the script and change the CREATE statement for this table 'umbracoServer' by replacing one of the TIMESTAMP columns with today's date. You only need to change 'TIMESTAMP' to '2013-11-04' on one column as MySQL 5.5 can't have two columns with a default timestamp.
Umbraco 6 - which MySQL version is supported?
Hi,
What is the minimum version of MySQL server required to run Umbraco 6?
Thanks,
Paul
Maybe here:
Minimum System Requirements for Umbraco 6
Hi,
Thanks, I'd already seen that, but it doesnt exactly say what the mininum required version of MySQL is.
My issue is that most shared hosting providers (I know I know, I'm being tight ;-)) are still using MySQL versions older than 5.6 which from what I've gathered is the mininum.
I have found a good provider that offers everything I need apart from they are currently on MySQL 5.5.
My question is really, will Umbraco 6 work on MySQL 5.5?
Hope someone can shed some light.
Thank you
Hi Paul,
Hopefully someone is already running 6 on the version of MySQL you want it to work with and they might see the post and might shed some light.
However if you want to find out straight away then why not have a crack at setting it up in a dev environment and see if it works?
Cheers,
Mark.
To confirm, after a little playing around Umbraco 6 will work on a MySQL 5.5 server.
to get this to work you need to:
1. Create the database via the usual installation on a MySQL 5.6 instance.
2. Export the database as a script
3. Edit the script and change the CREATE statement for this table 'umbracoServer' by replacing one of the TIMESTAMP columns with today's date. You only need to change 'TIMESTAMP' to '2013-11-04' on one column as MySQL 5.5 can't have two columns with a default timestamp.
4. Run the import
Hope this helps the next guy!
is working on a reply...