Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Paul Stoker 39 posts 72 karma points c-trib
    Oct 31, 2013 @ 23:20
    Paul Stoker
    0

    Umbraco 6 - which MySQL version is supported?

     

    Hi,

    What is the minimum version of MySQL server required to run Umbraco 6?

    Thanks,

    Paul

  • MK 429 posts 905 karma points
    Oct 31, 2013 @ 23:35
  • Paul Stoker 39 posts 72 karma points c-trib
    Nov 01, 2013 @ 10:07
    Paul Stoker
    0

    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

  • Mark Bennett 199 posts 375 karma points
    Nov 01, 2013 @ 10:43
    Mark Bennett
    0

    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. 

  • Paul Stoker 39 posts 72 karma points c-trib
    Nov 04, 2013 @ 15:36
    Paul Stoker
    0

     

    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!

Please Sign in or register to post replies

Write your reply to:

Draft