MySQL 5.0 and DNN - SQL and SQL Server

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

3/16/2010 5:26 AM

steve callahan

Joined: 5/13/2009

Posts: 67

MySQL 5.0 and DNN

We are looking to host a website with a VPS solutions company. They offer MySQL 5.0 as a standard package which we have not used before. We currently use MSSQL Server 2005 with our other DNN systems and would like to know if MySQL would work with a DNN system that is likely to experience a lot of traffic.

If this will work is there anywhere we can go to outline what is needed to set it up.

Many Thanks

3/16/2010 5:38 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: MySQL 5.0 and DNN

Steve, to use DNN with MySQL, you need dataproviders for both the core framework and all modules. AFAIR there has been a user publishing a core provider for DNN 4.8.x with very few core modules, but AFAIK it hasn't been updated since. be aware, that you will need at least 1GB of dedicated RAM if you are running DNN on a machine, MS SQL Server may eat up another GB.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

3/16/2010 5:41 AM

Stéphane Tétard

dotnentuke.aricie.com
Joined: 2/25/2005

Posts: 127

Re: MySQL 5.0 and DNN Modified By Stéphane Tétard on 3/16/2010 5:43:33 AM

(I'm afraid my post is coming too late...)

In theory, DotNetNuke allows you to change the dataProvider to use other systems such as Oracle or even MySQL.
In practice, it requires to have such a provider for the version of DotNetNuke you use. It's true for the Core scripts, but also for all modules you want to use. You will also have to get MySQL scripts for updates if you intend to update your instance.

I knew there was a company which sold Oracle DataProvider but I don't if it exists for MySQL.


Stéphane TETARD ARICIE - Member of DotNetNuke France

3/16/2010 5:52 AM

steve callahan

Joined: 5/13/2009

Posts: 67

Re: MySQL 5.0 and DNN

Thank you for your reply. If I understand you correctly, using MySQL will mean that the modules we currently use with MSSQL Server wont work with MySQL. However, we can get a DNN site up and running with MySQL but only if we source the dataproviders from someone like AFAIK. The RAM required isn't a problem so would you suggest that we continue to use MSSQL Server 2005 and refrain from using MySQL?

3/16/2010 5:57 AM

steve callahan

Joined: 5/13/2009

Posts: 67

Re: MySQL 5.0 and DNN

I have just realised that when you refer to AFAIR you mean 'as far as I remember'. However, I think I understood the context of what you were saying and that using MySQL over MSSQL Server would be a mistake.

Page 1 of 3

1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)