MySQL Database Version

I finished developing my site locally using ASP.NET 2.0 and MySQL 5.1.11

I then connect to my remote account, discountasp.net MySQL version is 4.1.18 !!! I am using lots of MySQL features in my local site that aren't available to my hosted DB. Am I missing the area to move to the next version, or is discountasp.netonly allowing this slightly older version?

Thanks!!

 

Discountasp MySQL version is 4.1.14. If you have developed your web application with MySQL 5.1.11, I don't think this version is backwards compatible.

 

Thanks, wish I had known discountasp.net was a full release behind..

I guess I can convert my stored procs to text.. the joy.

 

Well there is good reason to be "a full release behind." There are significant changes in MySQL 5.x that break a lot of code that was written to work with MySQL 4.x.


Many UNIX hosts run 4 and 5 side by side for that reason. As we're not especially MySQL-centric here (understandably, as the overwhelming majority of our customers use MSSQL as opposed to MySQL), it doesn't make sense to support both versions concurrently.


We may seem slow to make major upgrades to things like php and MySQL, compared to a *NIX host. The reason being demand is not great, and the downside is often considerable (as in major php and MySQL upgrades).

mjp

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service

 

It would be nice if you could just click a button and *bam* your 4.x MySQL will work in 5.x! I was thinking I just needed to find the spot on my control panel for the option to run in 5.x, but I couldn't find it. Then I was wondering too why you aren't runningtwo versions (or even more), either concurrent as you said, or on different servers. But if you don't offer it, then you don't.

I like the ASP.NET functionality of this host vs. others, so Istill will use it for this MySQL + ASP.NET project.

I'm not MySQL centric either, but this was a requirement of my task. During this projectI've found MySQL 5.x (and 6.x alpha) is becoming very close to MSSQL for functionality within the ASP.NET world,not quite as seemless, but its getting close!

It looks like I can just dothe couple ofMySQL stored procedures as plain text instead.. and my tables are compatible already with 4.x. Just a little extra work.