DotNetNuke Data Provider for MySQL is a data access layer based on dotConnect for
MySQL. It allows DotNetNuke to work with MySQL server. This topic provides information
on installing and using DotNetNuke Data Provider for MySQL.
DotNetNuke is a well-known open source content management system with rich functionality
that covers the widest variety of web developers' needs. It is built on the Microsoft
ASP.NET (VB.NET) platform, and is easily installed and hosted. For more information
on the product, refer to the
DotNetNuke official site. Its architecture allows you to connect to any relational
database management system, but as for now there is only database supported by default
- Microsoft SQL Server.
However, MS SQL Server is not considered as an ideal solution for web applications.
It is not a secret that nowadays MySQL is the most popular database used in web
projects, and, naturally, some developers would like to use the MySQL database with
Devart offers an easy and efficient solution that provides MySQL connectivity for
DotNetNuke projects. Our DotNetNuke Data Provider for MySQL is a complete replacement
for the default DotNetNuke SQL Server data provider. It works in conjunction with
our another product – dotConnect for MySQL, and this combination allows you
to utilize the MySQL database in your DotNetNuke projects as if it was a MS SQL
Note that DotNetNuke Data Provider for MySQL should be downloaded from the site
separately from the dotConnect for MySQL installation. To download the file, visit
the following page: http://www.devart.com/dotconnect/mysql/download.html
DotNetNuke Data Provider for MySQL includes data layers for the following modules:
To start using DotNetNuke Data Provider for MySQL, perform the following steps.
Note that these actions should be taken on your development machine, not the production
server. For instructions on how to setup your DotNetNuke project on the production
server, please refer to the Deployment section.
Make sure dotConnect for MySQL* is installed on your development web
Unpack the compressed file mysqldnn.zip to the root folder of your site.
DotNetNuke files should be there already.
Note that some files will be overwritten, so it is recommended that you make a backup
Adjust the connection string to match your configuration for all "SiteMySqlServer"
occurrences in the DevartMySql-DNN-126.96.36.199.config file and rename it to
Web.config. Also check that the assemblyBinding section contains proper
values. The section is well commented, so you will know what to update.
Start the initialization routine of the site and follow the wizard. The necessary
database objects and data will be created in the database you specified in the connection
Note that upgrade of database objects is not supported.
* If you are a registered user of dotConnect for MySQL, you can use your
Standard or Professional Edition in conjunction with DotNetNuke Data Provider for
MySQL. If you do not have a license for dotConnect for MySQL, you can download and
use its Trial Edition for the period of 30 days.
Follow these instructions if you are deploying your DotNetNuke project on a shared
web hosting, where you should not install dotConnect for MySQL.
DotNetNuke Data Provider for MySQL has been tested with dotConnect for MySQL 4.50
and DotNetNuke version 188.8.131.52. MySQL Server version should be 5.0 or higher. Please
note that compatibility with other versions of DotNetNuke is not guaranteed.